Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and more.
Get startedGrow your Fabric skills and prepare for the DP-600 certification exam by completing the latest Microsoft Fabric 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 |
---|---|
84 | |
71 | |
71 | |
68 | |
55 |
User | Count |
---|---|
94 | |
92 | |
91 | |
77 | |
70 |