Power BI is turning 10! Tune in for a special live episode on July 24 with behind-the-scenes stories, product evolution highlights, and a sneak peek at what’s in store for the future.
Save the dateEnhance your career with this limited time 50% discount on Fabric and Power BI exams. Ends August 31st. Request your voucher.
Hello Users,
I need to create one custom column using Power Query / DAX
as per below images, i have one column conatins code against each item Name
in result i need one column that conatins only single line for each item (IF both item having same code)
please find below images for refrence. i need output as per shown in output snapshot.
Thanks in Advance.
Solved! Go to Solution.
Hi @Dhrutivyasa-070 you can create NEW table in Power BI as following:
Proud to be a Super User!
cobovalues =
CALCULATE(DISTINCT(code),CONCATENATE([item],"+",[item]),SUM(Qty),IF(COUNTROWS(DISTINCT(code),"Combo","-")))
Hi @Dhrutivyasa-070 you can create NEW table in Power BI as following:
Proud to be a Super User!
Thanks for the solution, it worked for me!
please try the following measures
Item (Combo) =
CONCATENATEX ( VALUES ( 'Table'[Item] ), 'Table'[Item], ", " )
Total Qty =
SUM ( 'Table'[Qty] )
Remark =
IF ( COUNTROWS ( VALUES ( 'Table'[Item] ) ) > 1, "Combo", "-" )
User | Count |
---|---|
22 | |
11 | |
8 | |
6 | |
6 |
User | Count |
---|---|
26 | |
13 | |
11 | |
9 | |
6 |