subtract from previous row

[subburaj]

Hi Friends...Need your help in creating measure that subtract value from previous row and it has to re-start with the same logic when the next quarter starts. Please find the attached screenshot for your reference. I already have a measure called “X”. I need your help to create X1 measure that subtract value of X from previous row. Example, please find the attached the excel (C and D column). 1 quarter contains 13 weeks. Kindly do the needful.

[v-chuncz-msft · Accepted solution]

@subburaj,

Try using CALCULATE Function to change the context.

• https://community.powerbi.com/t5/Desktop/Year-on-year-for-previous-reporting-period/m-p/326661#M1457...
• https://www.sqlbi.com/articles/filter-arguments-in-calculate/