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.
Today's Sales = CALCULATE(sum(SALES[Sales]),LASTDATE(SALES[Ship Date]))
This gives me $30,384 in the "Card" tile.
I create a "Matrix" tile and put Today's Sales in the Values section and "Category" from the "Part Number Master" table in the Rows section. The total is correct, $30,384 but the information above the total does not actually total $30,384. Anyone have any ideas?
Solved! Go to Solution.
Hi @Anonymous,
Actual issue is the usage of LASTDATE function. It picks last date of a column in current context. Let's assume, one category which doesn't has sales for today, during the calculation for that category, it will pick yesterday's sales but in total or card, current context is for all entire table regardless of category so it will pick today's date.
You should use TODAY function.
Hi @Anonymous,
Actual issue is the usage of LASTDATE function. It picks last date of a column in current context. Let's assume, one category which doesn't has sales for today, during the calculation for that category, it will pick yesterday's sales but in total or card, current context is for all entire table regardless of category so it will pick today's date.
You should use TODAY function.
That makes since. Thank you!
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 |
---|---|
112 | |
97 | |
85 | |
67 | |
59 |
User | Count |
---|---|
150 | |
120 | |
100 | |
87 | |
68 |