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 everyone, I'm trying to simply group values by time of day to assign a 'group name'
For example
If Time is between 9.30am and 12:30pm then "Morning"
If Time is between 12:30pm and 3:30pm then "Afternoon"
If Time is between 3:30pm and 6:30pm "Late Afternoon"
If Time is between 6:30pm and 9:30pm then "Evening"
I'm trying this in custom column, but keep getting errors so I'm unsure of the simplest way to approach this.
Thanks in advance if you can lend some advice!
Solved! Go to Solution.
Here is a sample:
Column = IF([Time]>TIMEVALUE("9:30 AM") && [Time]<TIMEVALUE("12:30 PM"),"Morning","Not Morning")
Basically big nested IF statement.
Here is a sample:
Column = IF([Time]>TIMEVALUE("9:30 AM") && [Time]<TIMEVALUE("12:30 PM"),"Morning","Not Morning")
Basically big nested IF statement.
Thanks smoupre! I see exactly where I went wrong
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 |
---|---|
115 | |
100 | |
88 | |
68 | |
61 |
User | Count |
---|---|
152 | |
120 | |
102 | |
87 | |
68 |