Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!
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
Solved! Go to 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
)
To convert it to a measure, just wrap [update timestamp] with MAX( ) in @amitchandak 's expression.
Pat
To learn more about Power BI, follow me on Twitter or subscribe on YouTube.
@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
)
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
User | Count |
---|---|
42 | |
28 | |
23 | |
18 | |
15 |
User | Count |
---|---|
54 | |
35 | |
18 | |
18 | |
15 |