How to transform Calculated Column function to Measure

[Newbie2712]

I have this function but it only work in calculated column but i want it to be a measure

Please help me 

Thanks for your help

data: 

I want it to be like this:

[v-xinruzhu-msft · Accepted solution]

Hi @Newbie2712 

You can use offset function.

e.g  

Measure = CALCULATE(SUM('Table'[TotalOrder]),OFFSET(-1,ALLSELECTED('Table'[Mon]),ORDERBY([Mon],ASC)))

Output

Best Regards!

Yolo Zhu

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

[Ashish_Mathur]

Hi,

Share some data in a format that can be pasted in an MS Excel file and show the expected result.