Forum Discussion
Help _ duplicates
Hi,
i ve Table with some codes and their Issued POs. as output, I ll need to keep only non duplicated Code & counting for me the issued POs.
i've tried to use the below measure at least to find number of POs issued for those cases with "/", but i didn't succeed to get what i'm looking for as output.
Thanks for your support.
| LEN(Local_SubCo_DB[PO Number ])-LEN(SUBSTITUTE(Local_SubCo_DB[PO Number ],"/",""))+1 |
show how you wrote, maybe you missed something
also try writing like this:
5 Replies
show how you wrote, maybe you missed something
also try writing like this:
Based on your description, I created data to reproduce your scenario. The pbix file is attached in the end.
https://1drv.ms/u/s!AiUZ0Ws7G26RhxWFgowhCzKpxLeN?e=ioWVaKThanks a lot, when I apply it to my case, I got the following msgerror
very good , now it's working. what is the difference between the two (3O and max lent..) ?
Thanks a lot
very good , now it's working. what is the difference between the two (3O and max lent..) ?
Thanks a lot
