Forum Discussion

Jyo27's avatar
Jyo27
Icon for Helper II rankHelper II
3 years ago
Solved

Time range

Hi , How to calculate if else statement for  time range ? want to create custom column in power query.   Appreciate your help.
Need Help
  • Anonymous's avatar
    Anonymous
    3 years ago

    Hi Jyo27 ,

     

    Please try:

     

    = Table.AddColumn(
Previousstepsname, 
"Custom", 
each if [Time] >= #time(5, 0, 0) and [Time] < #time(12, 0, 0) then "A" 
else if [Time] >= #time(12, 0, 0) and [Time] <= #time(17, 0, 0) then "B" 
else null
)

     

     

    Best Regards,
    Gao
    Community Support Team

     

    If there is any post helps, then please consider Accept it as the solution  to help the other members find it more quickly. If I misunderstand your needs or you still have problems on it, please feel free to let us know. Thanks a lot!

    How to get your questions answered quickly --  How to provide sample data in the Power BI Forum

Anonymous's avatar
Anonymous
Not applicable
3 years ago

Hi Jyo27 ,

 

Please try:

 

= Table.AddColumn(
Previousstepsname, 
"Custom", 
each if [Time] >= #time(5, 0, 0) and [Time] < #time(12, 0, 0) then "A" 
else if [Time] >= #time(12, 0, 0) and [Time] <= #time(17, 0, 0) then "B" 
else null
)

 

 

Best Regards,
Gao
Community Support Team

 

If there is any post helps, then please consider Accept it as the solution  to help the other members find it more quickly. If I misunderstand your needs or you still have problems on it, please feel free to let us know. Thanks a lot!

How to get your questions answered quickly --  How to provide sample data in the Power BI Forum