I have 3 columns:
Bl= represents the number of the order, there is multiple arrows by BL because orders have differents products
ENTMVT: represent the sales (610 means command has been sent) SORMVT: represent the return (700 means order has been billed, 610, order has been returned)
I want to keep only BL which alls arrows are 610 (in fact i want to see how many commands are totally return) to visualize in Power Bi but i didnt find a conditional sum fonction in power bi to do so (with the conditional column tool)
can you help me with this matter?

Aucun commentaire:
Enregistrer un commentaire