Solved: Help _ duplicates

Zakaria_1980 · ‎04-08-2023

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

Ahmedx · ‎04-09-2023

show how you wrote, maybe you missed something

also try writing like this:

View solution in original post

Zakaria_1980 · ‎04-09-2023

very good , now it's working. what is the difference between the two (3O and max lent..) ?

Thanks a lot

Zakaria_1980 · ‎04-09-2023

very good , now it's working. what is the difference between the two (3O and max lent..) ?

Thanks a lot

Ahmedx · ‎04-09-2023

show how you wrote, maybe you missed something

also try writing like this:

Zakaria_1980 · ‎04-09-2023

Thanks a lot, when I apply it to my case, I got the following msgerror

Ahmedx · ‎04-08-2023

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=ioWVaK