Fabric is Generally Available. Browse Fabric Presentations. Work towards your Fabric certification with the Cloud Skills Challenge.
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)) )
Check out the November 2023 Power BI update to learn about new features.
Read the latest Fabric Community announcements, including updates on Power BI, Synapse, Data Factory and Data Activator.