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
I'm new to Power BI desktop
I'm using the data from the Retail Analysis Sample
I created 2 charts one that shows the sales by month using the following DAX expression
Sales = SUM(Sales[Sum_Regular_Sales_Dollars])
and another chart that shows the YTD sales by month using the following expression
YTD Sales = CALCULATE(SUM(Sales[Sum_Regular_Sales_Dollars]), DATESYTD('Time'[Month]))
However I get the same results
Do you use a separate date table? Try to use the date field not the month field.
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 |
---|---|
107 | |
98 | |
77 | |
66 | |
53 |
User | Count |
---|---|
144 | |
104 | |
100 | |
86 | |
64 |