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.
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.