vendredi 12 novembre 2021

counditional Sum of arrows regrouped by type

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?

enter image description here

Aucun commentaire:

Enregistrer un commentaire