Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
All,
I'm lookig for a way to show the actuals per month up until a specific month. (Selection is done by a filter)
For all coming months I would need to show the forecast.
Any ideas on how to set this up?
Ps. I can't use MaxDate for this as I need to be able to select the month up until which I want Actuals.
Thanks in advance,
Can you please confirm wherever we have forecast numbers for future dates/month, for those date Actuals will be 0 or blank?
I know actuals for future doesn't make sense but at same time i have seen some revenue can flow for actuals as (-)ve numbers.
can you please clarify?
@V-lianl-msft I don't see how to add the pbix file, below a snip from the data source I'm using in DEV.
I would like to show, in a table, the Sales up to a specific date and the FCST afterwards.
This specific date is to be chosen by using a filter related to the column Month.
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
107 | |
100 | |
80 | |
63 | |
58 |
User | Count |
---|---|
148 | |
111 | |
94 | |
84 | |
67 |