Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
I have two fields, "Card #" and "Serial Number."
Each "Card #" should have an exact match in the "Serial Number" field. However, due to some formating issues, I know there are some "Card #" that don't have an exact match in the "Serial Number" field.
Is there a measure to identify which numbers in the "Card #" field do not have a match in the "Serial Number" field?
Hi @Anonymous ,
If you are looking for a measure which can show all the card # which does not matched the series number dynamicelly, We can try to use the following measure to meet your requirement:
Not Matched Card # = CONCATENATEX(FILTER('Table','Table'[Card #] <> 'Table'[Serial Number]),[Card #],UNICHAR(10))
If it doesn't meet your requirement, Could you please show the exact expected result based on the Tables that we have shared?
Best regards,
Try
EXCEPT(distinct(table[Card#], distinct(table[SerialNo]))
refer https://docs.microsoft.com/en-us/dax/except-function-dax
Appreciate your Kudos. In case, this is the solution you are looking for, mark it as the Solution. In case it does not help, please provide additional information and mark me with @
Thanks. My Recent Blog -
Winner-Topper-on-Map-How-to-Color-States-on-a-Map-with-Winners , HR-Analytics-Active-Employee-Hire-and-Termination-trend
Power-BI-Working-with-Non-Standard-Time-Periods And Comparing-Data-Across-Date-Ranges
Connect on Linkedin
If in the same table you can just use:
@Anonymous how does your data looks like? Are these in same table or different table? Read this post to get your answer quickly.
https://community.powerbi.com/t5/Community-Blog/How-to-Get-Your-Question-Answered-Quickly/ba-p/38490
Subscribe to the @PowerBIHowTo YT channel for an upcoming video on List and Record functions in Power Query!!
Learn Power BI and Fabric - subscribe to our YT channel - Click here: @PowerBIHowTo
If my solution proved useful, I'd be delighted to receive Kudos. When you put effort into asking a question, it's equally thoughtful to acknowledge and give Kudos to the individual who helped you solve the problem. It's a small gesture that shows appreciation and encouragement! ❤
Did I answer your question? Mark my post as a solution. Proud to be a Super User! Appreciate your Kudos 🙂
Feel free to email me with any of your BI needs.
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
110 | |
96 | |
77 | |
63 | |
55 |
User | Count |
---|---|
143 | |
109 | |
89 | |
84 | |
66 |