Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
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
@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.
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
115 | |
100 | |
88 | |
68 | |
61 |
User | Count |
---|---|
152 | |
120 | |
102 | |
87 | |
68 |