Forum Discussion
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."
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/
2 Replies
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/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!
