Log In
Register
Home
September 15, 2020
Offline
I am getting an error when I try to build out a conditional column to provide a time based on day.
For example, if day of week equals 0 (Sunday) or 6 (Saturday) make time 8:00 PM, otherwise 2-5 make time 10:00 PM
the column returns the literal #time(22,0,0)
Driving me crazy, can you help figure out the issue?
Thanks
Robb
See Answer
July 16, 2010
Offline
Hi Robb,
Please provide a sample Excel file showing what you're trying to do so we can reproduce the issue and better understand and help you.
Mynda
September 15, 2020
Offline
Hi Mynda
see Store Close error
if day = 0 then 8:00 PM
if day = 6 then 8:00 PM
all other days 2-5 then 10:00 PM
Not sure how conditional column should work in this case.
Thanks
July 16, 2010
Offline
Hi Robb,
Thanks for the file. Click on the last step in the query editor > go to the formula bar and remove the double quotes around the #time(... formulas, so that it looks like this:
= Table.AddColumn(#"Changed Type1", "store close", each if [In Day of Week] = 6 then #time(20, 0, 0) else if [In Day of Week] = 0 then #time(20, 0, 0) else #time(22, 0, 0))
Then change the data type to Time.
Mynda
Answers Post
1 Guest(s)
