March 31 - April 2, 2025, in Las Vegas, Nevada. Use code MSCUST for a $150 discount! Early Bird pricing ends December 9th.
Register NowGet certified in Microsoft Fabric—for free! For a limited time, the Microsoft Fabric Community team will be offering free DP-600 exam vouchers. Prepare now
Hi world!
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"****
ID, | TYPE, | FLAG, |
123 | house | 0 |
21232 | garage | 0 |
4235 | store | 0 |
24 | house | 0 |
garage | 1 | |
store | 1 | |
house | 0 | |
garage | 1 | |
store | 1 |
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.
@Anonymous
Try this formula
Column = IF(LEN(Table[COLUMN_D])=0 && Table[TYPE] <> "house",1,0)
OR
Column = IF(Table[COLUMN_D]=BLANK() && Table[TYPE] <> "house",1,0)
Try
Flag = IF(ISBLANK(Table2[ID]) && Table2[TYPE,] <> "House",1,0)
@Anonymous
Try this formula
Column = IF(LEN(Table[COLUMN_D])=0 && Table[TYPE] <> "house",1,0)
OR
Column = IF(Table[COLUMN_D]=BLANK() && Table[TYPE] <> "house",1,0)
There is a problem with the formula the PBI says the following " Token RoghtParen expected" and select the first coma "," -->
,1,0)
any idea?
@Anonymous
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 ' ; '
Ok I got it!!! I was trying to edit the query, I was in the wrong section.
Thanks all for the responses, BTW I needed ";" instead of ","
😉
March 31 - April 2, 2025, in Las Vegas, Nevada. Use code MSCUST for a $150 discount! Early Bird pricing ends December 9th.
Check out the November 2024 Power BI update to learn about new features.
User | Count |
---|---|
118 | |
97 | |
87 | |
71 | |
62 |
User | Count |
---|---|
138 | |
116 | |
114 | |
99 | |
98 |