cancel
Showing results for
Did you mean:

Grow your Fabric skills and prepare for the DP-600 certification exam by completing the latest Microsoft Fabric challenge.

Frequent Visitor

## DAX

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."

1 ACCEPTED SOLUTION
Super User

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 🙂

 Also happily accepting Kudos 🙂

 Feel free to connect with me on LinkedIn!

 #proudtobeasuperuser

2 REPLIES 2
Super User

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 🙂

 Also happily accepting Kudos 🙂

 Feel free to connect with me on LinkedIn!

 #proudtobeasuperuser

Frequent Visitor

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!