Forum Discussion

jtgriffin's avatar
jtgriffin
Frequent Visitor
6 years ago
Solved

Else If Formula Breaks One Dataset

Hello,    I have a custom column that I want to add to my data that contains an else if formula. I have used this formula in the past in Power BI with no problems, however it will only return "ERRO...
Need Help
  • VasTg's avatar
    VasTg
    6 years ago

    jtgriffin 

     

    Looks like M query. What was the error you got?

     

    Click on the cell which say error to see it.

     

    If this helps, mark it as a solution

    Kudos are nice too

VasTg's avatar
VasTg
Memorable Member
6 years ago

jtgriffin 

 

Looks like M query. What was the error you got?

 

Click on the cell which say error to see it.

 

If this helps, mark it as a solution

Kudos are nice too

jtgriffin's avatar
jtgriffin
Frequent Visitor
6 years ago

The error I get is as follows:

 

Expression.Error: We cannot apply operator < to types Number and Text.
Details:
Operator=<
Left=50000
Right=484

 

The 484 is the number in column "Ceiling Value ($K)/Contract Value". So it seems to be looking in the right spot. Any ideas why it wont apply the < operator? 

 

This is very strange. 

 

Thanks, 

JT

  • jtgriffin's avatar
    jtgriffin
    Frequent Visitor
    6 years ago

    Im new to PBI, but I think this was the issue. 

     

    I had the add column query placed after I told it to transform the data to decimal form for the ceiling value. Once I moved the data change type above the add custom column everything seemed to work. 

     

    Did think order mattered but apparently it does in that section. 

     

    Thanks for all the help!