Forum Discussion
Gangasaniravi
2 years agoHelper I
Variance sales between rows
Hi all , Looking for difference of sales available between rows. Date Sales Jan 21 100 Feb 21 120 Mar 21 150 Apr 21 May 21 350 Jun 21 July 21 100 Output ...
Jonvoge
2 years agoMost Valuable Professional
Hi.
You'll can use a Calculated Measure to return the Previous Period's sales, and compare it with your Current Period Sales.
If you are using a Date Table, try the following Measure:
Variance = SUM('Table'[Sales]) - CALCULATE(SUM('Table'[Sales]), DATEADD('Table'[Date], -1, MONTH))
If you are not using a Date Table, you should implement one according to a guide like this:
How to Create a Date Table in Power BI | Master Data Skills + AI (enterprisedna.co)
_____________________________________________________
I hope my comment was helpful.
If your question was answered, please mark your post as 'Solved' and consider giving me a 'Thumbs Up'.