The ultimate Microsoft Fabric, Power BI, Azure AI & SQL learning event! Join us in Las Vegas from March 26-28, 2024. Use code MSCUST for a $100 discount. Register Now
Hi experts... I need your help.
I have a quality database of my products where one of my information is the LOTE.
In my quality process I can disapprove a complete LOTE (mother lote), or simply part of the LOTE (Children Lote).
I identify a Mother Lote when the code does not have the hyphen (-) and the first 14 characters are the same as the first 14 characters of the child Lote.
In that case, when I reject the Mother Lote, I need to disregard the child lotes from my analysis. For example:
I tried several ways to mark these children lotes with some flag, but I could not find a correct way to do this programming.
Anyone have any idea how to do it?
Solved! Go to Solution.
Try this for your calculated column. Bear in mind that I am assuming here that IDs for Mother Lotes always have 14 characters and IDs for Children Lotes always 17 as you show.
Table1[Delete] = VAR IsChildrenLote = (LEN(Table1[Lote])=17) RETURN IF(IsChildrenLote; IF(CONTAINS(Table1;Table1[Lote];MID(Table1[Lote];1;14));"X")
)
Join us at our first-ever Microsoft Fabric Community Conference, March 26-28, 2024 in Las Vegas with 100+ sessions by community experts and Microsoft engineering.
User | Count |
---|---|
158 | |
106 | |
96 | |
83 | |
75 |
User | Count |
---|---|
154 | |
137 | |
131 | |
81 | |
62 |