Forum Discussion
Advocate IIMDX error message : Expression error: The name 'DIVIDE' wasn't recognized. Make sure it's spelled c
Hi Moh_ali_square,
>>even the syntex checker is marking green.
Power query not support these functions, actually the syntax check only check the formula name and parameters type.
In power query. you can direct use "/" to calculate with divide; for if statement you should use it like below formula:
if expression then value_if_true else value_if_false
Reference:
Insert a custom column into a table (Power Query)
Power Query - Overview and Learning
BTW, I'd like to suggest you use the dax formula(report view), it support these functions which you mentioned.
Regards,
Xiaxin Sheng
Hi Moh_ali_square,
Which type of query you use? Power query or dax query? Can you share some detail content of your issue? (e.g. table structs)
BTW, there is not divide function in power query.
Regards,
Xiaoxin Sheng
Advocate IIHi Anonymous
I am using Power Query.
the error comes for many functions, like divide, IIF, IF.
even the syntex checker is marking green.
Hi Moh_ali_square,
>>even the syntex checker is marking green.
Power query not support these functions, actually the syntax check only check the formula name and parameters type.
In power query. you can direct use "/" to calculate with divide; for if statement you should use it like below formula:
if expression then value_if_true else value_if_false
Reference:
Insert a custom column into a table (Power Query)
Power Query - Overview and Learning
BTW, I'd like to suggest you use the dax formula(report view), it support these functions which you mentioned.
Regards,
Xiaxin Sheng