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.
I have this table:
We have a strange way of calculating our revenue... In order to project our revenue for the future for each company, what we have to do is get the revenue total from two months prior and multiply that total by 12. So in plain terms for March it would be:
(Sum of Revenue from January by Delta Account) * 12
So as each month progresses (since this is dynamic data) the formula would look back to Feburary totals for April once April is here, March totals for May once May is here, etc.
How would I go about setting that up?
Solved! Go to Solution.
Hi @Anonymous,
Maybe this formula will help.
Measure = CALCULATE ( SUM ( Table1[Revenue_Amount_c] ), DATESINPERIOD ( 'Calendar'[Date], MAX ( 'Calendar'[Date] ), -3, MONTH ) ) * 12
Best Regards,
Dale
Hi @Anonymous,
Maybe this formula will help.
Measure = CALCULATE ( SUM ( Table1[Revenue_Amount_c] ), DATESINPERIOD ( 'Calendar'[Date], MAX ( 'Calendar'[Date] ), -3, MONTH ) ) * 12
Best Regards,
Dale
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 |
---|---|
110 | |
94 | |
81 | |
66 | |
58 |
User | Count |
---|---|
150 | |
119 | |
104 | |
87 | |
67 |