Forum Discussion
Calculation
I have two table named Sales and Shops. I want to do is if Shop Name from Sales table and Shop from Shops table data are same, return Qty column from Sales Table. If not same, Divide Qty with Unit ...
Hi Anonymous ,
Data model:
I think you can try this code to create a calculated column in shops table.
Column = VAR _QTY = CALCULATE(SUM(Sales[Qty])) VAR _ALL = SUM(Sales[Qty]) RETURN IF(_QTY = BLANK(), DIVIDE(_ALL,Shops[Unit]),_QTY)Result is as below.
Best Regards,
Rico ZhouIf this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Hi Anonymous ,
Data model:
I think you can try this code to create a calculated column in shops table.
Column =
VAR _QTY = CALCULATE(SUM(Sales[Qty]))
VAR _ALL = SUM(Sales[Qty])
RETURN
IF(_QTY = BLANK(), DIVIDE(_ALL,Shops[Unit]),_QTY)Result is as below.
Best Regards,
Rico Zhou
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.