Highlight Today and Yesterday Both based on measure

[Raman3456]

Hi guys,

Need to create measure based on the "Date" filed as today & yesterday then green color , other than "Red color 

Please suggest me if any idea

Regards,

Raman

[aj1973]

Hi @Raman3456 

Add a measure like this,

IF(OR(DATE[column] = today()), DATE[column] = today() - 1), "Green", "Red")

Then use the measure as conditional formating

[Raman3456]

HI Aj,

Thanks for the prompt reply ,

while using OR conditon in measure it is not showing the column name .

is there any other way .

Date is in Hierarchy.

Regards,

Raman

[aj1973]

here is an example

Color =

var _today = SELECTEDVALUE(Table[Date])

var _yesterday = _today - 1

return

IF(AND(_today = TODAY(), _yesterday), "Green", "Red")

Use AND instead of OR

[Raman3456]

I want to apply backgorund color to the date 

thanks for the reply 

[aj1973]

[Raman3456]

Every dates is coming green only 

if anydate not in yesterday or today it should be red.

Thanks .

[Raman3456]

HI Aj,

Color =

VAR _today=SELECTEDVALUE('EHPBIPrc And EHPBIAcute'[LastRefreshDate].[Date])

Var _Yesterday=TODAY()-1

return

if(OR(_today=TODAY(),_Yesterday),"Green","Red")

is this correct?

[aj1973]

Replace OR by AND

[Raman3456]

My requirement is ( If date=today or yesterday then Green color rest all dates should be red color ).

but as on the screeshot everything will be getting red color only .

Thanks for the support AJ.

[aj1973]

Can you export that visual to Excel and send it to me please? I will take care of it

[Raman3456]

I am unable to send my file with you .

[aj1973]

[Raman3456]

Access has been provided

[aj1973 · Accepted solution]

I Split column LatestLastRefresh into 2 columns Date and Time.

https://drive.google.com/file/d/1kKVzzBYtQxVdyhfc6MZxLSlYY_DvsfLk/view?usp=sharing

Let me know if all good.

[Raman3456]

Thank you so much Aj its working fine now.

Cheers

[aj1973]

Can't you share it on a cloud service like Onedrive, googledrive...

The URL?

[Raman3456]

https://docs.google.com/spreadsheets/d/1rg6NL3U4U0Ilmot9xR_FJu2l21LcXi_r/edit#gid=344102978

please go through the link