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,
Probably very simple but I can't seem to find a way for the life of me.
Basically I have two cards, one is showing the total profit in the current month(February) and I want the other to show the previous month so January in this case. But I want those to update automatically at months move on.
For the first card I simply have the filter set to "Show items when the value: is in this month"
But how do I set it for the previous month i.e. January and not last 30 days?
Many thanks,
Kamil
Solved! Go to Solution.
You should have an option for the last "Calendar month".
Hi,
You can create new column in your calendar table to highlight previous month
Period = Switch( True(),
eomonth(Date[Date],0) = eomonth(Today(),-1),"Previous month" ,
Format(Date[Date],"MM YYYY"))
and then, when the date changes, previous month will move along. Simply use it as a filter for the card
You should have an option for the last "Calendar month".
It turns out that I'm just very blind. Sorry and thank you.
Not at all! I got stuck on this too with week and month haha!
Hi,
you could apply the filter in the calculation not in the Filter pane.
CALCULATE("Total profit"), PREVIOUSMONTH('Date'[Date]))
Br
User | Count |
---|---|
77 | |
77 | |
68 | |
67 | |
49 |
User | Count |
---|---|
108 | |
104 | |
93 | |
83 | |
64 |