Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!
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.
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
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.
User | Count |
---|---|
141 | |
113 | |
104 | |
77 | |
64 |
User | Count |
---|---|
135 | |
123 | |
101 | |
71 | |
61 |