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
2 Replies
- amitchandak
Super User
ajinwlee , 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.
