Forum Discussion

Power_BI_Outlaw's avatar
Power_BI_Outlaw
Regular Visitor
2 years ago
Solved

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...
  • lbendlin's avatar
    2 years ago
    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? 🙂