Forum Discussion
DAX comparison do not support comparing values of type integer with values of type text
Hi Guys Im having this issue when trying to create a calculate column. I Type in the following condition: Column = IF ( 'Table1'[Issue Resolution] = "NA", 0, 15 )
tamerj1
Community Champion
Community ChampionAnonymous
You need to apply this to all columns. Use power query for that. Select all the numerical columns and replace NA wil null or 0.
Other thing I noticed, it would be much easier if you first unpivot all the numerical columns then replace the null. Then In DAX you can do something like
Base Points = CALCULATE ( SUM ( Table1[Value] ), Table1[Attribute] IN { "Issue Resolution Points", "Complete and Accurate Information Points", etc..... } )
This is Report that is going to be feed live by automatic responses submited in Form, that form have an excel that is the one that feed the Report. If a use power query is only going to apply for the existent data right? and the new data?
- tamerj1
Anonymous
Then you neef to fix it from the source.