Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!
Hello everyone,
I'm trying to simulate an exercise from Microsoft PowerBi course in EDX.org, about using meassures and more specifically YTD and SamePeriodLast Year command.
The powerbi project file provided by the course is here : Github Download Link
Using these data, by applying DAX commands for YTD Revenue and LY YTD as below, the numbers I get back are the same for both years which makes the calculation for YTD Variance to be zero.
YTD Revenue = TOTALYTD(SUM(Sales[REevenue]),'Date'[Date])
YTD LY = CALCULATE([YTD Revenue],SAMEPERIODLASTYEAR('Date'[Date]))
YTD Var = [YTD Revenue] - [LY YTD]
I would appriciate if you can help me with choosing the right Date table and fixing the LY YTD
Solved! Go to Solution.
@sinadvd , looking at screenshot , I doubt either the join with date table is disabled or not there. Please check the join.
Make sure the date table is marked as the date .
The formula seems correct for LY you can also try
YTD LY = TOTALYTD(SUM(Sales[Reevenue]),dateadd('Date'[Date],-1,year))
@sinadvd , looking at screenshot , I doubt either the join with date table is disabled or not there. Please check the join.
Make sure the date table is marked as the date .
The formula seems correct for LY you can also try
YTD LY = TOTALYTD(SUM(Sales[Reevenue]),dateadd('Date'[Date],-1,year))
Thank you so much! the lack of relational connection was the reason!
User | Count |
---|---|
124 | |
108 | |
99 | |
62 | |
62 |
User | Count |
---|---|
137 | |
115 | |
102 | |
71 | |
61 |