Earn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It 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 |
---|---|
98 | |
90 | |
82 | |
73 | |
67 |
User | Count |
---|---|
115 | |
102 | |
98 | |
71 | |
67 |