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.
Hello,
I need an advice. I'm trying to calculate the Rolling 12M and what I need when it comes to the months of rolling 12 is as below
If I'm looking in Jan 2022 then my 12 month previous should be Jan 2021 -Dec 2021 not Feb 2021-Jan 2021. Ideally in the the 12M the current month should be excluded.
I used the below DAX but ofcourse here the start date is Max(Date[day]). I tried replacing that with dateadd function to pick up a table to set up the start date month as previous month. But nothing was working
Solved! Go to Solution.
@sandeep_me , try like
@sandeep_me , try like
Thanks a lot @amitchandak . I used another logic eventhough I was getting the answer my total was not reading the last month total and your dax was giving the right totals as well.
Join the community in Stockholm for expert Microsoft Fabric learning including a very exciting keynote from Arun Ulag, Corporate Vice President, Azure Data.
User | Count |
---|---|
84 | |
84 | |
66 | |
63 | |
62 |
User | Count |
---|---|
199 | |
120 | |
110 | |
79 | |
69 |