Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!
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.
User | Count |
---|---|
141 | |
113 | |
104 | |
78 | |
64 |
User | Count |
---|---|
136 | |
125 | |
107 | |
70 | |
61 |