Variance sales between rows

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'.

Hi Jonvoge  Thank you for the help, Need to show variance of slaes last available sales and current available sales, if there is no sales then variance also blank .