Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and a 50 percent discount on exams.
Get startedEarn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.
Hi All
I have a issue , when i my Date expression :-
CALENDAR(Date(2003,01,01),date(2021,12,31))
Today is Jan 18 2022 ,My YTD expression below it will return Last year Total sales amount.
Solved! Go to Solution.
Hi Paul,
Couple of things: Have you gone through the process of marking your Date table as a calendar table? (Right click the table name from your Fields pane > Mark as date table > Mark as date Table > select your unique date column)
If so, then you can simplify your expression to just be:
CALCULATE (
[SALES],
DATESYTD('DATES'[Date])
)
Then you can add a year slicer to your canvas. Whichever year you select will give you the YTD value for that value for that year.
Cheers
Hi Paul,
Couple of things: Have you gone through the process of marking your Date table as a calendar table? (Right click the table name from your Fields pane > Mark as date table > Mark as date Table > select your unique date column)
If so, then you can simplify your expression to just be:
CALCULATE (
[SALES],
DATESYTD('DATES'[Date])
)
Then you can add a year slicer to your canvas. Whichever year you select will give you the YTD value for that value for that year.
Cheers
This is the best reply i get in 2022. Thank you very much. it is what i am looking for.
Paul
User | Count |
---|---|
89 | |
75 | |
69 | |
65 | |
58 |
User | Count |
---|---|
103 | |
94 | |
74 | |
60 | |
59 |