Limit 1 Line to specific date

Power_BI_Outlaw — Wed, 13 Mar 2024 21:55:31 GMT

Hey

I have a visual showing the minimum and maximum temperatures over a 3 year period. I've created a measure that calculates the average 5 year minimum temperatures. I don't want to effect the calculation of the meausre, but only require the measure to be shown from October 1, 2024 as the average data before this period isn't required and I think it'll clean the visual up a little bit.

Any insight on how to accomplish this before my laptop ends up smashed on the ground (joking).

Average Min Year = CALCULATE(AVERAGE('4A - ENVIRONMENT CANADA'[MIN_TEMPERATURE]),DATEADD('4A - ENVIRONMENT CANADA'[DATE],-5,YEAR))

Re: Limit 1 Line to specific date

lbendlin — Thu, 14 Mar 2024 00:21:46 GMT

a measure that calculates the average 5 year minimum temperatures

That's not what your measure does

only require the measure to be shown from October 1, 2024

Add an IF statement

Measure = IF(max('4A - ENVIRONMENT CANADA'[DATE])>dt"2024-10-01"),result)

How are you planning to collect temperatures from the future? 🙂

topic Re: Limit 1 Line to specific date in DAX Commands and Tips

Limit 1 Line to specific date

Re: Limit 1 Line to specific date