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 i...
Need Help
Show and Tell
Tips and Tricks
Greg_Deckler's avatar
Greg_Deckler
Icon for Community Champion rankCommunity Champion
3 years ago

FredDeb Try:

Measure = MINX(FILTER('Table',[A1.2b] > 4),[Install Date])
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...