Reference Previous Quarter's Value

[Kitchsinky6432]

I'm trying to reference the previous quarter's Value in a query. My ultimate goal is to be able to sum up the present value of differences between the current value and the previous value for all quarters. For example, for the quarter 1 row, I want to do (110 - 100)/(1.025^1). For quarter 2, (90-110)/(1.025^2). And so forth - then sum up all of those values.

I saw a potential solution to sort columns then add an index row to be able to reference the previous row's value, but I cannot get this to work properly.
This is in Power BI.

 

[Matt Allington]

You should get a calendar table And join it to this data table, even if the calendar table only contains the quarter column.

Create calendar Tables in Power BI

Learn how to create a Power BI calendar table using the basic rules and approach to setting it up daily, weekly or monthly.

exceleratorbi.com.au

Then you can use custom Time Intelligence patterns to solve the problem.

DAX Time Intelligence Explained

Level: Beginners I help a lot of people on forums who ask questions about time intelligence for DAX. If you are just starting out then the chances are that you may not even be clear what time intelligence is and hence sometimes you don’t even know what to ask. Often [...]Read More »

exceleratorbi.com.au