Help with date filter

[Anonymous]

Hello all!

I'm trying to fix this and still can't figure out how to do it

I 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.

https://drive.google.com/file/d/17gw86tjxqN3xfcc2rWJ9Ag3UA1yQSOgn/view?usp=sharing 

Thanks,

Monica

[amitchandak]

@MonicaElizondo, Based on what I have

Test a measure such as

if(day(today()) <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 Tips
We appreciate your congratulations.