Check your eligibility for this 50% exam voucher offer and join us for free live learning sessions to get prepared for Exam DP-700.
Get StartedDon't miss out! 2025 Microsoft Fabric Community Conference, March 31 - April 2, Las Vegas, Nevada. Use code MSCUST for a $150 discount. Prices go up February 11th. Register now.
I'm creating a new column that will return something according to the time in another column. This column that will be consulted does not show the date, it only shows the time (it's like 06:30 for example).
My formula looks like this (and it doesn't work):
IF(TableName[Hour]>= 06:00 && TableName[Hour]< 12:00, "Morning")
I want to do something that shows if it's morning, afternoon or night depending on the information in the [Time] column.
But the above formula doesn't work... I suspect I must convert the "06:00" somehow but I still don't know how.
Solved! Go to Solution.
I solved the problem!
I opened my Excel and put an hour and changed its the type. Instead of hour type I chose to view the data as number.
Then, 06:00 is the same as 0.25, 14:00 is the same as 0.5833 and so on.
IF(TableName[Hour]>= 0.25 && TableName[Hour]< 0.5833, "Morning")
I solved the problem!
I opened my Excel and put an hour and changed its the type. Instead of hour type I chose to view the data as number.
Then, 06:00 is the same as 0.25, 14:00 is the same as 0.5833 and so on.
IF(TableName[Hour]>= 0.25 && TableName[Hour]< 0.5833, "Morning")
March 31 - April 2, 2025, in Las Vegas, Nevada. Use code MSCUST for a $150 discount! Prices go up Feb. 11th.
Check out the January 2025 Power BI update to learn about new features in Reporting, Modeling, and Data Connectivity.
User | Count |
---|---|
143 | |
79 | |
63 | |
52 | |
47 |
User | Count |
---|---|
212 | |
89 | |
76 | |
66 | |
60 |