Hello everyone,
here is a Power BI beginner.
I'm looking for a way to hide the current month through a filter in a visual.
The key figure fluctuates a lot and so I only want to show valid data from the last few months.
How is that possible?
Thanks in advance.
Best regards
Alex
Solved! Go to Solution.
@poweralex , you can create a measure like
calculate([measure], filter(Table, Table[Date] <= eomonth(Today(), -1)) )
@poweralex , you can create a measure like
calculate([measure], filter(Table, Table[Date] <= eomonth(Today(), -1)) )
User | Count |
---|---|
101 | |
84 | |
69 | |
49 | |
48 |
User | Count |
---|---|
149 | |
95 | |
78 | |
71 | |
68 |