DAX

[AayWhy]

Hi,

I need help with my DAX. I need to convert whole number to time with length (LEN)/digits ranging from 1 to 4. I wrote this but it's not working:

IF(LEN(flights[#"SCHEDULED_DEPARTURE - Copy"])=4,
LEFT(flights[#"SCHEDULED_DEPARTURE - Copy"],2)&":"&RIGHT(flights[#"SCHEDULED_DEPARTURE - Copy"],2),

IF(LEN(flights[#"SCHEDULED_DEPARTURE - Copy"])=3,
LEFT(flights[#"SCHEDULED_DEPARTURE - Copy"],1)&"0:"&RIGHT(flights[#"SCHEDULED_DEPARTURE - Copy"],2),

IF(LEN(flights[#"SCHEDULED_DEPARTURE - Copy"])=2,"00:"&RIGHT(flights[#"SCHEDULED_DEPARTURE - Copy"],2),

"00:0"&RIGHT(flights[#"SCHEDULED_DEPARTURE - Copy"],1)))))

I get this in return: "Expression.Error: The name 'IF' wasn't recognized. Make sure it's spelled correctly."

[tackytechtom · Accepted solution]

Hi @AayWhy ,

Your code looks good to me. I created a calculated column in DAX with it and got the following result:

The only thing I noticed is that you had one parentheses too many.

So, this might be a wild guess: Could it be that you are trying to write the logic in M (Power Query) instead of DAX?

If so, Power Query uses the following syntax for if clauses:

if [ColumnA] = 1 then [ColumnA] else [ColumnB] 

Let me know if this helps 🙂

/Tom
https://www.tackytech.blog/
https://www.instagram.com/tackytechtom/

[AayWhy]

Hi Tomfox,

Thank you helping me figure this out, everything is working now. And your guess was right. Still trying to explore Power BI actually.

Thanks again!