Forum Discussion
Find Missing Value
How about everyone, Very good day
Thank you very much for the answers
I found the next thing that worked for me and it's what I was looking for
Make a calculated column.
RESULT =
VAR RequiredCodes = {"ES-01","ES-02", "ES-03","XX","YY"} -- Codes to search
VAR IdentifierCodes =
CALCULATETABLE(
VALUES(Table1[ChargeCode]), -- Valores ChargeCode
ALLEXCEPT(Table1,Table1[Identifier]) -- Removes filters, except for identifiers
)
VAR CodesMissing =
EXCEPT(RequiredCodes, Identifier Codes) -- Compares the required codes with those in the identifier
RETURN
IF(
COUNTROWS(MissingCodes) > 0,
"Missing: " & CONCATENATEX(MissingCodes, [Value], "), "), -- Concatenated Missing Codes
"All Codes"
)
The code compares the required load codes with the codes present for each identifier. If codes are missing, it returns a message listing which ones are missing; if they are not missing, it returns a message indicating that all codes are present.
Hi Syndicate_Admin ,
It looks like you have found a solution. Could you please mark this helpful post as “Answered”?
This will help others in the community to easily find a solution if they are experiencing the same problem as you.
Thank you for your cooperation!
Best Regards,
Yang
Community Support Team
If there is any post helps, then please consider Accept it as the solution to help the other members find it more quickly.
If I misunderstand your needs or you still have problems on it, please feel free to let us know. Thanks a lot!
Hi Syndicate_Admin ,
Have you resolved the issue? If yes, kindly mark the helpful answer as a solution if you feel that makes sense. Welcome to share your own solution. More people will benefit from the thread.
Should you have any further questions, feel free to reach out.
Thank you for being a part of the Microsoft Fabric Community Forum!Hi Syndicate_Admin ,
We haven’t heard back from you regarding our previous response and wanted to check if your issue has been resolved.If it has, please consider clicking “Accept Answer” and “Yes” if you found the response helpful.
If you still have any questions or need further assistance, feel free to let us know — we're happy to help!
Thank you!Hi Syndicate_Admin ,
We haven’t heard back from you regarding our previous response and wanted to check if your issue has been resolved.
If it has, please consider clicking “Accept Answer” and “Yes” if you found the response helpful.
If you still have any questions or need further assistance, feel free to let us know — we're happy to help!Thank you!
