cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
faizannaeem Regular Visitor
Regular Visitor

If a record is not updated in 7 days, mark it as "Not Updated"

Hello Everyone,


As you all can see in the picture below, I have log data for demands table which if not updated in 7 days, I would like to highlight. The tough part is that I want it to show "Not Updated" only for the latest record as log data can have the same ID repeating multiple times.

 

Capture.JPG

 

As you can see in the example above, Demand 1002 has been updated multiple times but for the last update only I want to calculate if it took more than 7 days, if yes then, it should be "Not updated"

I have tried a lot to figure it out but not able to do it. Can anyone help me with this problem.

 

To access the file, the link is 

 

https://www.dropbox.com/s/ct5ahnq06co8ygu/Need%20Help.pbix?dl=0

 

Thank you very much in advance

2 REPLIES 2
ekozelek Regular Visitor
Regular Visitor

Re: If a record is not updated in 7 days, mark it as "Not Updated"

Perhaps try to add a calculated column for days since update & then add a conditional column to show either the Demand_Status_Title if less than 7 days or Not Updated if greater than/equal to 7 days. 

jar2019 Regular Visitor
Regular Visitor

Re: If a record is not updated in 7 days, mark it as "Not Updated"

Similarly, you can combine the days since the last update to a dax function. 

 

Days since update = Datediff('table'[date],today(),day)

 

If you can figure out how to do this as a query that would be even better.