Conditional Measure using a Measure

[nlakshmi]

Hello,

I need help to create a conditional measure using the value in the Quality OK column. In the table below, the Quality OK is a measure created using a condition on a status column in the source table. Now, I need to create a new measure that will show the Max date, if Quality OK is not blank and show "None", if there is a value in the Quality OK column.

Carrier	Leg	Container ID	Quality OK	Cleared	Min Date	Max Date
Mediterranean Shipping Co	US - TH	689654	10	53	7/30/2022	12/16/2022
Mediterranean Shipping Co	US - TH	693315		12	8/26/2022	12/26/2022
Maersk	US - SL	693650		34	8/27/2022	12/16/2022
Maersk	US - TH	202269	4	2	10/6/2022	12/16/2022
Maersk	US - TH	202269		5	10/7/2022	10/27/2022
COSCO Group	US - SL	202370	3		1/13/2023	2/9/2023

Thank you.

[Anonymous · Accepted solution]

Hi @nlakshmi ,

I have created a simple sample, please refer to it to see if it  helps you.

Create a measure.

Measure = IF([QUALITY OKK]=BLANK(),BLANK(),MAX('Table'[Max Date]))

If I have misunderstood the meaning, please provide more details with your desired output.

Best Regards
Community Support Team _ Polly

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.