Variance sales between rows

[Gangasaniravi]

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

	Jan 21	Feb 21	Mar 21	Apr 21	May 21	Jun 21	Jul 21
sales	100	120	150		350		100
Varience	-20	-30	-200		250

[Gangasaniravi]

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 .

[Jonvoge]

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