grouping and joining data usin full outer join

[Anonymous]

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

[v-yuta-msft · Accepted solution]

Hi DAX_Learner,

You can use query editor-> Transform-> Group By to ahieve this requirement.

 

Regards,

Jimmy Tao