Forum Discussion

cocoloco79's avatar
cocoloco79
Icon for Helper III rankHelper III
5 years ago
Solved

DAX to Show value when 0

Hello.   I'm reaching out becasue I'm stuck with a formula. I like to calculate the qty of corn cobs used for Prepack and Losse products. Cobs Qty = (Query1[QtyInner]*Query1[QtyPieces])*Query1[Bo...
Need Help
  • amitchandak's avatar
    amitchandak
    5 years ago

    cocoloco79 , not very clear.

     

    A new column like

    Cobs Qty = if(Query1[QtyPieces] <>0 , (Query1[QtyInner]*Query1[QtyPieces])*Query1[Boxes],(Query1[QtyInner])*Query1[Boxes])

manikumar34's avatar
manikumar34
Icon for Solution Sage rankSolution Sage
5 years ago

cocoloco79 

Not clear, but try something like below.

if(Query1[QtyPieces] =0 , Query1[QtyInner],Query1[QtyPieces])

 

Regards, 

Manikumar