Keeping track of the last date something was imported

[Anonymous]

Hi all,

I want to keep up with the last date of when my data was imported. In my data it's issue_date. 

At this moment I'm using a card to display the value. Is it possible to change the date when it does not matches the day to a color (red)? Or is there another way to do this?

[amitchandak · Accepted solution]

Hope you might have taken it from table

like

max date = maxx(table, table[last issue date])

Now create a measure

if(datediff([max date],today(),day)>1, "red","green")

In card you have background color, when you take the mouse to color line, you will see three dots. Use conditional formatting. There choose "Field" option and choose this measure

Appreciate your Kudos. In case, this is the solution you are looking for, mark it as the Solution. In case it does not help, please provide additional information and mark me with @
Thanks. My Recent Blog -
Winner-Topper-on-Map-How-to-Color-States-on-a-Map-with-Winners , HR-Analytics-Active-Employee-Hire-and-Termination-trend
Power-BI-Working-with-Non-Standard-Time-Periods And Comparing-Data-Across-Date-Ranges

Connect on Linkedin

[Anonymous]

Thank you @amitchandak ! It works very well.