topic Re: Calculation in DAX Commands and Tips

Calculation

Anonymous — Sun, 19 Mar 2023 12:00:44 GMT

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 column from Shops.

I can't find the best solution for it. How can I do that?

amitchandak — Mon, 20 Mar 2023 03:02:45 GMT

Anonymous , Create a common Dimension Shop from both the tables (if have date, create date too) and use that in conditional formatting

Power BI- Power Query: When I asked you to create common tables: https://youtu.be/PqfGW6pl1Sw

Anonymous — Fri, 24 Mar 2023 09:16:51 GMT

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.