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])

amitchandak's avatar
amitchandak
Icon for Super User rankSuper User
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])

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

    Thank you very much, spot on!