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.
Dear Community, good morning.
You would need to create a field that contains the last 5 YTDs (but not in multiple calculations), but in a single one to be able to use it as an x-axis in a Chart.
Since I have a calendar table, I was thinking of using an IF + Datesbetween function (
, indicating that if the date was within a certain period, I would put the "YTD xxxx" field, but it doesn't work.
Could you help me or comment on your experience in similar situations?
Thank you!
maybe you can try
if([date] >=date(2021,9,1) && [date]<=date(2022,10,31),"cumple","no cumple")
Proud to be a Super User!
User | Count |
---|---|
86 | |
82 | |
68 | |
67 | |
55 |
User | Count |
---|---|
123 | |
100 | |
90 | |
83 | |
66 |