Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!

Reply
Anonymous
Not applicable

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
Anonymous
Not applicable

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. 

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. 

Helpful resources

Announcements
April AMA free

Microsoft Fabric AMA Livestream

Join us Tuesday, April 09, 9:00 – 10:00 AM PST for a live, expert-led Q&A session on all things Microsoft Fabric!

March Fabric Community Update

Fabric Community Update - March 2024

Find out what's new and trending in the Fabric Community.