Forum Discussion
Power_BI_Outlaw
2 years agoRegular Visitor
Limit 1 Line to specific date
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 c...
- 2 years ago
a measure that calculates the average 5 year minimum temperaturesThat's not what your measure does
only require the measure to be shown from October 1, 2024Add 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? 🙂
lbendlin
Super User
2 years agoa 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? 🙂