power bi desktop

[Anonymous]

Is there any way to highlight whenever there is system date and report date not equal? Basically, I want to highlight Report date.

Please refer to attached screenshot for more information. 

[amitchandak]

@Anonymous ,

Create a table with this column in power query (Table Log - Column Date)

= Date.From(DateTime.FixedLocalNow())

then in dax create a measure and check

if(Max(Table[Date]) = Today() , 1,0 )

You can use this flag to highlight