Join us for an expert-led overview of the tools and concepts you'll need to pass exam PL-300. The first session starts on June 11th. See you there!
Get registeredPower BI is turning 10! Let’s celebrate together with dataviz contests, interactive sessions, and giveaways. Register 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 ","
😉
This is your chance to engage directly with the engineering team behind Fabric and Power BI. Share your experiences and shape the future.
Check out the June 2025 Power BI update to learn about new features.
User | Count |
---|---|
84 | |
76 | |
75 | |
43 | |
36 |
User | Count |
---|---|
109 | |
56 | |
52 | |
48 | |
43 |