Forum Discussion
Compare values between rows of custom data
Hi I'm new to Power BI. Why does #"Added Index"{[Index]-12}[Total] work only if [Total] is not an added/custom column? How do I get this to work on custom culumns? I'm trying to compare histori...
You can create a measure that is equal to the sum of your three columns.
Then you can create a measure that is equal to the sum of your three columns from the same period last year using
Calculate(yourmeasure, sameperiodlastyear(date))
https://msdn.microsoft.com/en-us/library/ee634972.aspx <----Sameperiodlastyear documentaiton