Forum Discussion

spmabaso's avatar
spmabaso
Regular Visitor
6 years ago
Solved

PowerBI DAX If function with time

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] >= timeval...
Need Help
  • Mariusz's avatar
    Mariusz
    6 years ago

    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"

     

    Best Regards,
    Mariusz

    If this post helps, then please consider Accepting it as the solution.

    Please feel free to connect with me.
    LinkedIn

     

Mariusz's avatar
Mariusz
Community Champion
6 years ago

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"

 

Best Regards,
Mariusz

If this post helps, then please consider Accepting it as the solution.

Please feel free to connect with me.
LinkedIn

 

  • spmabaso's avatar
    spmabaso
    Regular Visitor
    6 years ago

    Both Worked perfectly, thanks Mariusz !