Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
Hello guys
I have an matrix that informs the following information:
Product | Current sales | Last year sales | Previous year total sales |
Product 1 | 200,00 | 50,00 | 1.000,00 |
Product 2 | 100,00 | 60,00 | 2.000,00 |
Product 3 | 20,00 | 40,00 | 3.000,00 |
Product 4 | 50,00 | 50,00 | 4.000,00 |
Product 5 | 100,00 | 100,00 | 5.000,00 |
Product 6 | 40,00 | 40,00 | 5.000,00 |
Product 7 | 50,00 | 50,00 | 200,00 |
Current sales: Is the sum of the sales in the passed days in the current month till yesterday.
Last year sales: It's pretty much the same thing of current sales but in the last year.
E.g.: Today is day 9. So I need sales from day 1 to day 8 of this year and the previous year.
Previous year total sales: Total sales for the same month in the previous year E.g.:
It's May/17. Then the matrix shows the sales of whole May/16.
I have 2 report level filters: Month and year.
I tried to make last year sales with dax formulas but I did not succeed. Is there a dax formula that does this?
I have two tables: the classic calendar and the other is salestable.
connections:
calendar 1 - * salestable
thanks
Hi @Paulompm,
I have found a similar thread, please refer to the solution to check whether it applies to your scenario.
Compare MTD with previous period
Regards,
Yuliana Gu
Something like this should work:
Current Sales := SUM(SalesTable[Sales])
Current Sales MTD := CALCULATE([Current Sales], DATESMTD(Calendar[Date]))
Current Sales MTD - PY := CALCULATE([Current Sales], DATEADD(DATESMTD(Calendar[Date]), -1, YEAR)))
unfortunately current Sales MTD Is reporting the full-month sale of May not only the MTD. This information is also good but I also need to know the MTD of May last year.
Would it be acceptable to adjust your calendar table to STOP on the last day you have sales? Then, I think you would get what you want?
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
111 | |
95 | |
77 | |
69 | |
52 |
User | Count |
---|---|
146 | |
109 | |
106 | |
88 | |
61 |