Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
7 years ago
Solved

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's avatar
    v-yuta-msft
    Icon for Community Support rankCommunity Support

    Hi DAX_Learner,

     

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

     

     

    Regards,

    Jimmy Tao