Hide current month

Question

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

amitchandak · Accepted Answer

Anonymous , you can create a measure like 
&nbsp;
calculate([measure], filter(Table, Table[Date] &lt;= eomonth(Today(), -1)) )

Forum Discussion