Microsoft Fabric Community Conference 2025, March 31 - April 2, Las Vegas, Nevada. Use code MSCUST for a $150 discount.
Register nowThe Power BI DataViz World Championships are on! With four chances to enter, you could win a spot in the LIVE Grand Finale in Las Vegas. Show off your skills.
Hello experts,
I wanted to create a calculated column where:
if Column A = Column B, display 1. else 0.
but the issue is, sometimes both column are "Blank", so it will detect as the same, so it will display as 1, not 0.
i want if both blank, display 0.
Really need your help on this.
Thanks in advance.
Zety
Solved! Go to Solution.
@Anonymous i hope this helps you!THANK YOU!!
try this
Column = IF('Table'[ID] == BLANK() || 'Table'[Index] == BLANK() , 0,
IF('Table'[ID] = 'Table'[Index] , 1 , 0))
Hi @Anonymous
Please check below:
Revised =
IF (
AND ( ISBLANK ( Tables[Id] ), ISBLANK ( Tables[Index] ) ),
0,
IF ( Tables[Id] = Tables[Index], 1, 0 )
)
Hope it helps.
Hi @Anonymous
Or in your column terms, it would be:
Revised =
IF (
AND ( ISBLANK ( Tables[Column A] ), ISBLANK ( Tables[Column B,] ) ),
0,
IF ( Tables[Column A] = Tables[Column B,], 1, 0 )
)
Hope it helps.
THANK YOU ALL !! YOU GUYS ARE AWESOME! APPRECIATE IT ! :)))))
Hi @Anonymous
Or in your column terms, it would be:
Revised =
IF (
AND ( ISBLANK ( Tables[Column A] ), ISBLANK ( Tables[Column B,] ) ),
0,
IF ( Tables[Column A] = Tables[Column B,], 1, 0 )
)
Hope it helps.
Hi @Anonymous
Please check below:
Revised =
IF (
AND ( ISBLANK ( Tables[Id] ), ISBLANK ( Tables[Index] ) ),
0,
IF ( Tables[Id] = Tables[Index], 1, 0 )
)
Hope it helps.
try this
Column = IF('Table'[ID] == BLANK() || 'Table'[Index] == BLANK() , 0,
IF('Table'[ID] = 'Table'[Index] , 1 , 0))
@Anonymous i hope this helps you!THANK YOU!!
User | Count |
---|---|
123 | |
69 | |
67 | |
58 | |
52 |
User | Count |
---|---|
183 | |
92 | |
67 | |
62 | |
53 |