Forum Discussion
Anonymous
7 years agoNot applicable
grouping and joining data usin full outer join
EVALUATE
ADDCOLUMNS(
VALUES('Inc_$Item Ledger Entry'[Item No_]),
"PurchReq",CALCULATE(SUM('Inc_$Requisition Line'[Quantity (Base)]))
)
I am trying to group the data by Item NO which would display the sum of Quantity (Base) as per item.
But I am not getting required output.
Item No_] PurchReq
1000 4563
1100 4563
..
its giving same sum for all item no
Any suggestions would be welcome
Thank you
Hi DAX_Learner,
You can use query editor-> Transform-> Group By to ahieve this requirement.
Regards,
Jimmy Tao
1 Reply
- v-yuta-msft
Community Support
Hi DAX_Learner,
You can use query editor-> Transform-> Group By to ahieve this requirement.
Regards,
Jimmy Tao