03-09-2018 07:01 AM - last edited 06-27-2018 13:32 PM
Imagine you have a table that only includes YTD Revenue such as this:
Year Month Revenue YTD
You wish to reverse engineer the montly revenue figures. You can use a measure such as this:
Periodic Revenue = VAR MyMonth = MAX(RevenueYTD[Month]) VAR MyYear = MAX(RevenueYTD[Year]) RETURN SUM(RevenueYTD[Revenue YTD]) - CALCULATE( SUM(RevenueYTD[Revenue YTD]) ,FILTER( ALL(RevenueYTD) ,RevenueYTD[Month]=MyMonth-1 && RevenueYTD[Year]=MyYear ) )
Proud to be a Datanaut!
I have the question: if I want know the Total (sum) of Periodic Revenues?
If I enable display of the total in PowerBI, these are the results.
Total Revenues YTD = $290
Total Periodic Revenus = $290 (it' wrong)
I ask you for help.