Forum Discussion
need help to divide with 2 condition
Hey danzen ,
Thanks for the clarification. Since you're using a simple Excel file imported into Power BI, here’s how you can calculate the number of cartons per document using Power Query.
Load both tables into Power BI
Click Home > Get Data > Excel and load both sheets (Table 1 and Table 2).
Open Power Query
Go to Home > Transform Data.
Rename the tables:
StockTable (for Table 1)
BoxQtyTable (for Table 2)
Merge the tables
In StockTable, go to Home > Merge Queries > Merge Queries as New
Select Document and Customer from both tables
Join kind: Inner Join
Expand the merged table
After merging, click the small expand icon next to the new column
Select only the [qty in the box] column to expand
Add a Custom Column for Cartons:
Go to Add Column > Custom Column
Name it Cartons
Formula:
[Stock] / [qty in the box]
Close & Apply 😊
If you found this solution helpful, please consider accepting it and giving it a kudos (Like) it’s greatly appreciated and helps others find the solution more easily.
Best Regards,
Nasif Azam
Hi danzen , is this the solution / output you were looking for? I'll attach the image below for your reference. Let me know I've understood it correctly. I'll attach the file link in case this is what you were looking for. Let me know if there are some changes. Thanks
Hi SundarRaj , yes i want that specific result , could you please support how to write that formula, thank you very much.
Sure danzen, did you happen to check out the file? You'll see the entire code and process. Let me know if you need a step by step explaination of it. Thanks
hello Sundar,
your solution applies but is it is very compressed and shortened for beginner like myself.
i thank you for your support.