Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
5 years ago

subtracting two columns

Hey guys,

 

Im trying to compute a very easy dax that i cant compute.

Im just trying to substract two columns fom the same table with the follow dax:

 

dZ2Cantidad = sum('Z2'[Cons. Qty.])- sum('Z2'[Prod.Net.Qty.])




The result i am getting is (4.599.271,34) when it should be (2.303.276)


What  i am doing wrong?

 

Thanks in advance

1 Reply

  • Anonymous's avatar
    Anonymous
    Not applicable

    Can you please share your data or sample power BI file?