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.
Hi All, I have tw tables Actuals and forecast that are connected through calendar table via calendar date.
I want to create a matrix where I can see one column that represents Actual/Forecast i.e. if actuals are not available then forecast amount should be added but if actual is available then only actuals should be updated in column.
Below is the expected output.
Year | Qtr | Actuals | Forecasted | Forecasted/Actuals |
2022 | Q1 | 500 | 300 | 500 |
2022 | Q2 | 600 | 400 | 600 |
2022 | Q3 | 0 | 150 | 150 |
2022 | Q4 | 0 | 500 | 500 |
1100 | 1350 | 1750 |
I tried to create a dax but not getting the correct output
Solved! Go to Solution.
You can do this much easier if you keep the Actuals blank (rather than at 0)
Forecasted/Actuals = COALESCE([Actuals],[Forecasted])
You can do this much easier if you keep the Actuals blank (rather than at 0)
Forecasted/Actuals = COALESCE([Actuals],[Forecasted])
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 |
---|---|
47 | |
24 | |
20 | |
15 | |
13 |
User | Count |
---|---|
51 | |
46 | |
39 | |
19 | |
19 |