Hi All,
I am using the rolling average quick measure in this bar graph, and the rolling average line is extending beyond the end of my data. How would I stop this at the end of the data? Is this an issue with the standard quick measure DAX? I have not made any changes to it. I would like it to stop where the data ends (May 2024)
1 ACCEPTED SOLUTION
@wiselyman3 Add an IF statement like IF( MAX('Date'[Date]) > TODAY(), [Measure], BLANK() )
@ me in replies or I'll lose your thread!!!
Instead of a Kudo, please vote for this idea
Become an expert!: Enterprise DNA
External Tools: MSHGQM
YouTube Channel!: Microsoft Hates Greg
Latest book!: The Definitive Guide to Power Query (M)
DAX is easy, CALCULATE makes DAX hard...
@wiselyman3 Add an IF statement like IF( MAX('Date'[Date]) > TODAY(), [Measure], BLANK() )
@ me in replies or I'll lose your thread!!!
Instead of a Kudo, please vote for this idea
Become an expert!: Enterprise DNA
External Tools: MSHGQM
YouTube Channel!: Microsoft Hates Greg
Latest book!: The Definitive Guide to Power Query (M)
DAX is easy, CALCULATE makes DAX hard...
Helpful resources
Power BI Monthly Update - April 2024
Check out the April 2024 Power BI update to learn about new features.
Fabric Community Update - April 2024
Find out what's new and trending in the Fabric Community.
