I came from the green side (Qlik) so I´ve found some problemns developing some "script" tasks that for sure you will help me
It´s really easy.
I want to add a new column (flag column) with values 0 and 1 when the following isntructions:
****Column ID is NULL AND Column TYPE is different than the value "house"****
In Qlik should be something like if(isnull(ID) and TYPE <>"house",1,0)
But I am a beginner in DAX model so I need some help
Solved! Go to Solution.
Where did you put the formula? It seems that you are creating a column using Power Query.
This is a DAX formula.
Also based on regional settings the comma can be replaced with semicolon ' ; '