Forum Discussion

FredDeb's avatar
FredDeb
Regular Visitor
3 years ago

How to create this measure

Hi All, 

I want to create a measure that returns the "install date" for the row where the value in column A1.2b goes above 4 for the first time. 

Result should be: "30/01/2023" 

If the condition is not met, than the measure should return the last date in column "install date"

Can someone help me please.

Thanks a lot...

 

Fred.

Need Help
Show and Tell
Tips and Tricks

2 Replies

    • FredDeb's avatar
      FredDeb
      Regular Visitor
      3 years ago

      Thanks a lot. This helps me on the way.

      I have a second question.

      How can I do this for every column and put that data in a new table...