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 another column if the original column is blank....and I can't seem to get it working. This is edad I have in my original calculated column 

 

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

 

any help would be greatly greatly appreciated. Thank you. 

Need Help

2 Replies

  • 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")
)