Earn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.
Hi,
Does anyone know or can help in calculating ytg with the DAX formula?
I try this:
Amount YTG :=
Var DaySelected = MAXX(DATEADD('Calendar'[Date],YEAR),'Calendar'[Date])
Var Year=DATE(MAX('Calendar'[Year]),
Var FilterDates=DATESBETWEEN('Calendar'[Date],DaySelected,Year)
Var Result = CALCULATE([Amount Total], FilterDates)
Best regards.
Solved! Go to Solution.
Year To Go = VAR __today = TODAY() VAR __maxDate = DATE(YEAR(__today),12,31) RETURN CALCULATE(SUM([Column 2]),FILTER('Calendar',[Date]>__today && [Date]<=__maxDate))
Year To Go = VAR __today = TODAY() VAR __maxDate = DATE(YEAR(__today),12,31) RETURN CALCULATE(SUM([Column 2]),FILTER('Calendar',[Date]>__today && [Date]<=__maxDate))
User | Count |
---|---|
98 | |
87 | |
77 | |
67 | |
63 |
User | Count |
---|---|
110 | |
95 | |
95 | |
64 | |
58 |