The ultimate Microsoft Fabric, Power BI, Azure AI, and SQL learning event: Join us in Stockholm, September 24-27, 2024.
Save €200 with code MSCUST on top of early bird pricing!
Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and more. Get started
Hello experts,
I need some help with some simple things(for some people).
I managed to make a graph with series for 4 years by month. I would like to show in graph only data last 3 months
For example to see now only months March, Feb and Ian. But if I run report in August to see August July and June for all 4 series.
Thank you
Solved! Go to Solution.
Actually I realized that is quite simple
:
IsInFilter = IF(SalesQry[Posting_Date].[MonthNo]=MONTH(TODAY()) || SalesQry[Posting_Date].[MonthNo]=MONTH(edate(TODAY(),-1)) || SalesQry[Posting_Date].[MonthNo]=MONTH(edate(TODAY(),-2)) ,TRUE(),FALSE())
Actually I realized that is quite simple
:
IsInFilter = IF(SalesQry[Posting_Date].[MonthNo]=MONTH(TODAY()) || SalesQry[Posting_Date].[MonthNo]=MONTH(edate(TODAY(),-1)) || SalesQry[Posting_Date].[MonthNo]=MONTH(edate(TODAY(),-2)) ,TRUE(),FALSE())
Hi @Anonymous,
That's great! Please mark your answer as solution.
Best Regards,
Dale
Join the community in Stockholm for expert Microsoft Fabric learning including a very exciting keynote from Arun Ulag, Corporate Vice President, Azure Data.
Check out the June 2024 Power BI update to learn about new features.
User | Count |
---|---|
137 | |
106 | |
105 | |
73 | |
59 |
User | Count |
---|---|
266 | |
127 | |
119 | |
100 | |
88 |