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!
I need help limiting my page to always dynamically pick up dates that include last three full years and current year.l
For example, if current year is 2023, I need the data to get 2023, plus year 2022, 2021 and 2020 - starting from 01/01/2020 (so three full years are picked up, plus current year)
I tried to use a relative date slicer, but it either lets you select last three "calendar" years - whicvh skips the current year, or last three years - which does not start from the beginning of the year.
I have a disconnected Date table with dates - how can I use a dax function to dymamically select that time segment? So far I could just set the filter to start with 01/01/2020 as a static date, but opnce we move into the year 2024, this date will not dunamically move to the next year,. I need a Dax to dymanically shift each year, to pick up last three full years and current year's data. THANKS!!!
Solved! Go to Solution.
try to do as in the screenshot
Thank you so much, it worked like a charm! 😉
Join the community in Stockholm for expert Microsoft Fabric learning including a very exciting keynote from Arun Ulag, Corporate Vice President, Azure Data.
Ask questions in Eventhouse and KQL, Eventstream, and Reflex.
User | Count |
---|---|
86 | |
84 | |
66 | |
62 | |
61 |
User | Count |
---|---|
197 | |
118 | |
108 | |
78 | |
69 |