Forum Discussion
getting diff between totals in irregular time period
Hi, I'm having a lot of help. I have another question. how to get diff between columns ( or rows) totals in irregular time period? Thank you
amitchandak
Super User
Super Userajinwlee , I think offset with allselected can do the job
Measure 4 = CALCULATE([Net], OFFSET(-1,ALLSELECTED('Date'[Month sort]), ORDERBY('Date'[Month sort])))
https://medium.com/microsoft-power-bi/power-bi-offset-function-84177cc2cafd
Dax Function Offset, Window, Index: https://youtu.be/KhkCALjHylE
Sorry I don't understand.