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.
I'm using the following DAX to get the 'Quantity_On_Request' for the same day last year. When I view the data in a table, the totals are correct by day, however the total is incorrect.
I don't undertand why the 'total' is incorrect, but but the daily numbers are.
PrevYear Demand Qty = CALCULATE(SUM(Billed_Order_Details[Quantity_On_Request]),DATEADD('Order Date'[Date],-1,year))
Hi
I will create a calculated measure using the following:
CALCULATE(SUM(Billed_Order_Details[Quantity_On_Request]), SAMEPERIODLASTYEAR('Order Date'[Date]))
Hope this help
Tomas
Hi Tomas
Thanks for the reply, but using 'SamePeriodLastYear' gives me the same results. See below, this is what shows on the 'Totals' line of the Table visual. The daily totals are correct, but it's the 'Total' thats now summing correctly.
Date PrevYear Demand Qty
11/12/2019 54,959
11/13/2019 48,124
Total 741,722
Sorry, I mistyped, it's the 'Total' line that's summing incorrectly.
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 |
---|---|
43 | |
25 | |
19 | |
15 | |
8 |
User | Count |
---|---|
58 | |
50 | |
44 | |
21 | |
19 |