Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
9 years ago
Solved

Conditional Column not working (M against Measure)

Hi,   If I use    Type of Sale = IF(insertBK[ClassOfBusiness] = "Bus Acc","BA",IF(insertBK[TrueCompany]="HOUSE ADVERT","House",IF(insertBK[iadclass] = 9014, "Local Remnant"," ")))   In a measur...
Need Help
  • MarcelBeug's avatar
    MarcelBeug
    9 years ago

    The M code has duplicated double quotes, contrary to the DAX code.

vanessafvg's avatar
vanessafvg
Community Champion
9 years ago

Anonymous powerquery is case sensitive, have you typed the condition exactly as it is in the data?

MarcelBeug's avatar
MarcelBeug
Community Champion
9 years ago

The M code has duplicated double quotes, contrary to the DAX code.