Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
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
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
47 | |
26 | |
19 | |
14 | |
10 |
User | Count |
---|---|
57 | |
49 | |
44 | |
18 | |
18 |