Hello @Max,
Thank you for posting your query onto the Forum.
Well it’s always difficult to judge the results in the absence of PBIX file. But still I think from the given screenshot provided by you is as follows -
-
The figures portrayed from “Jan - July” are the months that pertains to the current year and therefore based on that it’s showing the Forecast Percentage for those months because in your formula your context is applied as "TODAY() - 1 Month" and therefore it’s giving you the result for the July month as well since we’ve already entered this month.
-
Now for figures for the period from “August - December”, this figures might be pertaining to the last year and therefore it’s not able to showcase the results for those periods since we haven’t entered into those periods. But if you apply filter/slicers for the years such as “Current Year” and “Previous Year” those blank rows will get removed and you’ll see the results only for the period till date.
-
Alternatively, if you’re following the updated “Date” table which is already available in the forum in that case you can use the “IsAfterToday” column to filter out your results and to show the results only for the current period till date.
This similar type of problem was asked few days back onto the Forum by one of the member and it used to show similar sort of results. I’m providing a link of that query as well as working of my PBIX file about how we were able to tackle that problem by incorporating the 3rd option.
Hoping you find this useful and helps you to achieve the desired analysis.
Please feel free to write back in case I’ve missed out on anything.
Thanks & Warm Regards,
Harsh
Example Data (1).pbix (334.3 KB)