Nov 16 2020 11:08 PM
Hi dear Friends
I have problem to applying a formula in Dax or Power Query,
I have Some items, one list is for purchase and Selling of our items, each recodr show our selling, and purchase quantity is repeated,
We have four header fro each items, Item name, Date, Purchase quantity, sales Quantity and Supplier,
Now I need formula in DAX or Power Query to add one Column which it show me the number of Supplier for each items, For example for its " Sweet" we have 2 supplier ,
As I showed the table and the result which i want in Excel Sheet,
Thank you for your helping in advance ,
Nov 16 2020 11:41 PM
@Jalal_1988 DAX is not my speciality. Therefore, I'm offering you a PQ solution. See attached.
Nov 17 2020 12:20 AM
SolutionOr you may add another column with formula
=SUMPRODUCT(IF([Item]=[@Item],1/COUNTIFS([Item],[@Item],[Supplier],[Supplier]),0))
Nov 17 2020 12:20 AM
SolutionOr you may add another column with formula
=SUMPRODUCT(IF([Item]=[@Item],1/COUNTIFS([Item],[@Item],[Supplier],[Supplier]),0))