Earn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.
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 |
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 .
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'.
User | Count |
---|---|
97 | |
87 | |
77 | |
67 | |
63 |
User | Count |
---|---|
110 | |
95 | |
95 | |
64 | |
59 |