Power BI is turning 10! Tune in for a special live episode on July 24 with behind-the-scenes stories, product evolution highlights, and a sneak peek at what’s in store for the future.
Save the dateEnhance your career with this limited time 50% discount on Fabric and Power BI exams. Ends August 31st. Request your voucher.
Hello everyone!
I wanted to calculate the difference in sales values from month end values. For example, if my Sept 2022 MTD sales were 1000 and August 2022 MTD sales were 300, I should get a value of 700. I have various products - Biscuits, Chocolate, Drinks, etc as well as Product Categories - Food, Office Supplies, Furniture. Also, these calculations are only for each year ie, Jan 2022 should not calculate the difference of Jan 2022 values with Dec 2021.
In this case, is a calculated column better or a measure?
I really would appreciate any help!
Regards
So I solved the issue I was facing..in case anyone faces the same issue, here is my solution..
i created a calculated column:
in most cases, a measure. could you also provide some sample data?
Hi @FreemanZ
So my data starts from Nov 1, 2021 till Nov 30, 2022. I have just provided a screenshot of month end dates sample. I need to figure the difference in MTD values for each year, with it resetting at the start of each year..
Regards
Check out the July 2025 Power BI update to learn about new features.
User | Count |
---|---|
25 | |
10 | |
7 | |
6 | |
6 |
User | Count |
---|---|
30 | |
11 | |
11 | |
10 | |
6 |