Help with date filter

Question

Hello all!I'm trying to fix this and still can't figure out how to do itI want to find a way to do this:I used a filter with the current Month, my current month is the last month, for example in this case is September, and I want to show all the months until the current depending on the actual day (Today), for example if today were 15 of October, I want to see the months but I don’t want to see October, November, etc…. and if today were 16 of October, I want to see all the months, September, October, November, etc…I hope someone can help me with this.&nbsp;https://drive.google.com/file/d/17gw86tjxqN3xfcc2rWJ9Ag3UA1yQSOgn/view?usp=sharing&nbsp;Thanks,Monica

amitchandak · Answer

@MonicaElizondo, Based on what I have 
Test a measure such as
if(day(today()) &lt;16, [Last month], [this month])
 
See if you're neded : Power BI — Month-to-month with or without time intelligence https://medium.com/@amitchandak.1978/power-bi-mtd-questions-time-intelligence-3-5-64b0b4a4090e
 
 Provide your feedback and tips for new videos Dax Series Tutorial Vs SQL Direct Query PBI TipsWe appreciate your congratulations.

Forum Discussion

Help with date filter

1 Reply

Related content

Filter

Dynamic Filter

Inverse Filter

Override filters

Filter on Icons ?