Check your eligibility for this 50% exam voucher offer and join us for free live learning sessions to get prepared for Exam DP-700.
Get StartedDon't miss out! 2025 Microsoft Fabric Community Conference, March 31 - April 2, Las Vegas, Nevada. Use code MSCUST for a $150 discount. Prices go up February 11th. Register now.
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!!
March 31 - April 2, 2025, in Las Vegas, Nevada. Use code MSCUST for a $150 discount! Prices go up Feb. 11th.
Check out the January 2025 Power BI update to learn about new features in Reporting, Modeling, and Data Connectivity.
User | Count |
---|---|
143 | |
74 | |
63 | |
51 | |
47 |
User | Count |
---|---|
211 | |
83 | |
64 | |
60 | |
56 |