Forum Discussion
Calculated Column Discrepancy in Power BI - Concatenated Keys Issue
Hi achuri,
Per my test, I could not reproduce your issue by following your steps.
To troubleshoot your issue, please create a new calculated column to check if we can output values that are not the same between CombinedKey1 and CombinedKey2 (if any):
outputdifference = Var CombKeyTable1 = VALUES(Table1[CombinedKey1]) VAR CombKeyTable2 = VALUES(Table2[CombinedKey2]) RETURN EXCEPT( CombKeyTable1, CombKeyTable2)Also, make sure that Power BI Desktop is up to date and also create a new report to check if the issue still exists.
I hope my suggestions give you good ideas, if you have any more questions, please clarify in a follow-up reply.
Best regards,
Joyce
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Hi achuri,
Per my test, I could not reproduce your issue by following your steps.
To troubleshoot your issue, please create a new calculated column to check if we can output values that are not the same between CombinedKey1 and CombinedKey2 (if any):
outputdifference =
Var CombKeyTable1 = VALUES(Table1[CombinedKey1])
VAR CombKeyTable2 = VALUES(Table2[CombinedKey2])
RETURN
EXCEPT(
CombKeyTable1, CombKeyTable2)
Also, make sure that Power BI Desktop is up to date and also create a new report to check if the issue still exists.
I hope my suggestions give you good ideas, if you have any more questions, please clarify in a follow-up reply.
Best regards,
Joyce
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Thank you so much!! This approach was helpful. This helped me debug my issue and find the root cause of it.
Basically my Table1 holds mulitple values of Combined Key and Table2 was like a master data, so only unique values of Combined Key. My aim was to find missing or new Combined values from table 1 which are not present in Table 2.
More like a VLOOKUP function but in DAX, so I used Filter function along with Count Rows function and it works.
But thanks to you for helping me debug and guiding me with regards to the outputdifference table, that helped me understand my problem and tell me what I was missing!
