Forum Discussion

hsnluca's avatar
hsnluca
New Member
2 years ago
Solved

Create night shift range

  hello ,   I want add night shift in Power BI range in column selected from issue time column  (03:30 PM) to (10:00 PM)  so all time between this range will show in column  as N .    this xls ...
Need Help
  • edhans's avatar
    edhans
    2 years ago

    You posted this in the Power Query forum, so I have you M code for Power Query. 
    DAX has a very different syntax.

    New Column =
IF (
    Table1[issue time]
        >= TIME ( 15, 30, 00 )
        && Table1[issue time]
            <= TIME ( 22, 00, 00 ),
    Table1[issue time],
    BLANK ()
)
edhans's avatar
edhans
Icon for Community Champion rankCommunity Champion
2 years ago

The following formula in a new custom column will grab all times between 3:30pm and 10:00pm.

 

if [issue time] >= #time(15,30,00) and [issue time] <= #time(22,00,00) then [issue time] else null

 

 

hsnluca's avatar
hsnluca
New Member
2 years ago

Thank you for response, the sound good but the synatx error showing 

 

  • edhans's avatar
    edhans
    Icon for Community Champion rankCommunity Champion
    2 years ago

    You posted this in the Power Query forum, so I have you M code for Power Query. 
    DAX has a very different syntax.

    New Column =
IF (
    Table1[issue time]
        >= TIME ( 15, 30, 00 )
        && Table1[issue time]
            <= TIME ( 22, 00, 00 ),
    Table1[issue time],
    BLANK ()
)
    • hsnluca's avatar
      hsnluca
      New Member
      2 years ago

      Thank you ,it working apprechiate your help , but i think ihave some problem in my filed format , what about if format has date or AM , PM ?? for example in photo  

       

      • edhans's avatar
        edhans
        Icon for Community Champion rankCommunity Champion
        2 years ago

        Doesn't matter. That is formatting. The TIME() function uses military time, so TIME(15,0,0) is 3pm. My formula had both sides as PM times being 15 and 22 hrs...

         

        Could you mark my answer as the solution please so this thread can be marked as completed and others searching for similar info will know that works? Thanks!