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.
Hello everyone,
I need some urgent help with this one. I need to show the changes of the Total values, between the single forecast dates.
As in the Excel example the forecast date 01-2017 has the total value of 218.163, the change to the next forecast date (02-2017) is 13.700, and so on.
Is it possible to do it in Power Bi like in the excel example? If yes, do anyone have any idea?
Thank you guys in advance for your help 🙂
Solved! Go to Solution.
Hi @Billy0503,
To calculate the changes, you can firstly calculate the values of last month, then it should be easy to get the changes. The formula below is for your reference.
Changes = VAR currentYear = MAX ( 'Table'[Year] ) VAR currentMonth = MAX ( 'Table'[Year] ) RETURN SUM ( 'Table'[Values] ) - CALCULATE ( SUM ( 'Table'[Values] ), FILTER ( ALL ( 'Table' ), 'Table'[Year] = currentYear && 'Table'[Month] = currentMonth - 1 ) )
Regards
Hi @Billy0503,
To calculate the changes, you can firstly calculate the values of last month, then it should be easy to get the changes. The formula below is for your reference.
Changes = VAR currentYear = MAX ( 'Table'[Year] ) VAR currentMonth = MAX ( 'Table'[Year] ) RETURN SUM ( 'Table'[Values] ) - CALCULATE ( SUM ( 'Table'[Values] ), FILTER ( ALL ( 'Table' ), 'Table'[Year] = currentYear && 'Table'[Month] = currentMonth - 1 ) )
Regards
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 |
---|---|
109 | |
99 | |
77 | |
66 | |
54 |
User | Count |
---|---|
144 | |
104 | |
102 | |
87 | |
64 |