Divide into groups by time passed since updated

[Anonymous]

Hi,

I want to monitor how long time has passed since the values were updated. Does anyone know if there is a simple way to divide the values into groups based on the time passed. The four groups will be "24 hours ago", "1 week ago", "1 month ago" and "later".

You can find the pbix here: https://drive.google.com/file/d/1wjkaEM4wvv-plYSJR-HXdo9QKfRj5P19/view?usp=sharing

[amitchandak · Accepted solution]

@Anonymous , Create a new column like

New column =
var _days = datediff([update timestamp], today(),day)
return
switch(true(),
_day <=1 , "24 hours Ago",
_day <=7 , "A week ago ",
// Add other
"Way back" //Default
)

[Anonymous]

Hi @amitchandak ,

Thanks for your suggestion!

Is there a way to do this in a measure?

Or if not, can font color defining measures be based on calculated columns?

Juls

[mahoneypat]

To convert it to a measure, just wrap [update timestamp] with MAX( ) in @amitchandak 's expression.

Pat

[Anonymous]

Thank you for your help 🙂 @mahoneypat @amitchandak