Forum Discussion

YcnanPowerBI's avatar
YcnanPowerBI
Helper II
2 years ago
Solved

Problem with adding IF statement

Hello. I am pretty new here so please forgive me if I post in the wrong place, etc. But onto my issue. I have a calculated column that assigns a time interval to each row. I now need it to look at an...
Need Help
  • rubayatyasmin's avatar
    rubayatyasmin
    2 years ago

    Hi, YcnanPowerBI 

     

    Try this updated code,

     

    = Table.AddColumn(#"Changed Type", "Custom", each 
    let 
        actualTime = if [paidTime] = "" then [otherTime] else [paidTime]
    in 
        Time.From(Text.From(Time.Hour(Time.From(actualTime)))&":"&(if Time.Minute(Time.From(actualTime)) >= 30 then "30" else "0")&":00")
)

     

rubayatyasmin's avatar
rubayatyasmin
Community Champion
2 years ago

Hi, YcnanPowerBI 

 

Try this updated code,

 

= Table.AddColumn(#"Changed Type", "Custom", each 
    let 
        actualTime = if [paidTime] = "" then [otherTime] else [paidTime]
    in 
        Time.From(Text.From(Time.Hour(Time.From(actualTime)))&":"&(if Time.Minute(Time.From(actualTime)) >= 30 then "30" else "0")&":00")
)

 

  • YcnanPowerBI's avatar
    YcnanPowerBI
    Helper II
    2 years ago

    It worked, thank you so much!