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.
I am trying to categorise my column based on time as shown below. But my formula is returning an error.
Not quite sure whether using the timevalue function in this formula.
=if [Time] >= timevalue(06:00) and [Time]< timevalue (14:00) then "Morning"
else if[Time]>= timevalue(14:00) and [Time]< timevalue(22:00) then"Afternoon"
else if "Night"
Solved! Go to Solution.
Hi @spmabaso
if you are looking for DAX function try this.
Measure =
SWITCH(
TRUE(),
'Table'[Time] >= TIMEVALUE( "06:00" ) && 'Table'[Time] < TIMEVALUE( "14:00" ), "Morning",
'Table'[Time] >= TIMEVALUE( "14:00" ) && 'Table'[Time] < TIMEVALUE( "22:00" ), "Afternoon",
"Night"
)
in Power Query try this
= if [Time] >= #time( 6, 0, 0 ) and [Time] < #time( 14, 0, 0 ) then "Morning" else if [Time] >= #time( 14, 0, 0 ) and [Time] < #time( 22, 0, 0 ) then "Afternoon" else "Night"
Hi @spmabaso
if you are looking for DAX function try this.
Measure =
SWITCH(
TRUE(),
'Table'[Time] >= TIMEVALUE( "06:00" ) && 'Table'[Time] < TIMEVALUE( "14:00" ), "Morning",
'Table'[Time] >= TIMEVALUE( "14:00" ) && 'Table'[Time] < TIMEVALUE( "22:00" ), "Afternoon",
"Night"
)
in Power Query try this
= if [Time] >= #time( 6, 0, 0 ) and [Time] < #time( 14, 0, 0 ) then "Morning" else if [Time] >= #time( 14, 0, 0 ) and [Time] < #time( 22, 0, 0 ) then "Afternoon" else "Night"
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 |
---|---|
100 | |
54 | |
21 | |
12 | |
11 |