Get value based from same data and remark the value

Hi vividarinda 

Try this DAX expression using calculated column, 

Calculated Column =

VAR CurrentDate = 'Table'[Date]

VAR MaxValue = CALCULATE(MAX('Table'[Value]), FILTER('Table', 'Table'[Date] = CurrentDate))

VAR MinValue = CALCULATE(MIN('Table'[Value]), FILTER('Table', 'Table'[Date] = CurrentDate))

RETURN

    IF('Table'[Value] = MaxValue, "High", IF('Table'[Value] = MinValue, "Low", BLANK()))

 

 

 

DAX expression using Measure, 

Measure =

VAR MaxValue = CALCULATE(MAX('Table'[Value]), FILTER(ALL('Table'), 'Table'[Date] = MAX('Table'[Date])))

VAR MinValue = CALCULATE(MIN('Table'[Value]), FILTER(ALL('Table'), 'Table'[Date] = MAX('Table'[Date])))

RETURN

    IF(

        SELECTEDVALUE('Table'[Value]) = MaxValue, "High",

            IF(SELECTEDVALUE('Table'[Value]) = MinValue, "Low",BLANK()))

 

 

Make this setting if you are not able to view measure with blank values . Right click on date and choose show items with no data. 

 

 

Don't forget to give thumbs up and accept this as a solution if it helped you!!!

 

Thank you, 

 

vividarinda 

Thanks for sending over .pbix file.

I've slightly modifed DAX expression for calculated column. 

Try with this updated DAX 

Don't forget to give thumbs up and accept this as a solution if it helped you!!!

Thank you,