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.
Is there any Dax already built in to calculate the reminder of the year budget? For example, I want to be able to say what is my year to date Revenue in one column and then show the remainder revenue target for the year and calculate a ratio or %age for it. That way, I will be able to show what percentage or value is still left to be generated (or spent in the case of expenditure).
Solved! Go to Solution.
You could take a running total dax logic and use it a numerator and your yearly budget as a denominator
*** you will need a date/calendar table for this to work.
*** use this measure with date / month / quarter as your row headers
Budget Remainder % = VAR Numerator = CALCULATE ( [Sales Amount], FILTER ( ALL ( 'Date' ), 'Date'[Date] <= MAX ( 'Date'[Date] ) ) ) VAR Denominator = SUM ( Budget[Budget] ) RETURN 1-DIVIDE ( Numerator, Denominator, 0 ) // this should give you a remainder ratio
N -
You could take a running total dax logic and use it a numerator and your yearly budget as a denominator
*** you will need a date/calendar table for this to work.
*** use this measure with date / month / quarter as your row headers
Budget Remainder % = VAR Numerator = CALCULATE ( [Sales Amount], FILTER ( ALL ( 'Date' ), 'Date'[Date] <= MAX ( 'Date'[Date] ) ) ) VAR Denominator = SUM ( Budget[Budget] ) RETURN 1-DIVIDE ( Numerator, Denominator, 0 ) // this should give you a remainder ratio
N -
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 |
---|---|
114 | |
99 | |
83 | |
70 | |
61 |
User | Count |
---|---|
149 | |
114 | |
107 | |
89 | |
67 |