Forum Discussion

AayWhy's avatar
AayWhy
Frequent Visitor
4 years ago
Solved

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 - Cop...
Need Help
Show and Tell
  • tackytechtom's avatar
    tackytechtom
    4 years ago

    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/

tackytechtom's avatar
tackytechtom
Most Valuable Professional
4 years ago

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's avatar
AayWhy
Frequent Visitor
4 years ago

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!