Forum Discussion

Satish_Kumar's avatar
Satish_Kumar
Icon for Helper V rankHelper V
9 years ago
Solved

How to use group's in data

Help me in using Summerize command in DAX.   i am new at power bi.
  • Anonymous's avatar
    Anonymous
    9 years ago

    Hi Satish_Kumar,

     

    Please try below code if it works on your side.

     

    Sample:

     

    Tables.

     

    Formula:

     

    Summary Table = ADDCOLUMNS(SUMMARIZE(Sheet1,Sheet1[Document No_],Sheet1[Buy-from Vendor No_],"Sum of No",SUMX(FILTER(ALL(Sheet1),Sheet1[Document No_]=EARLIER(Sheet1[Document No_])),Sheet1[Amount Including Tax])),"Posting Date",LOOKUPVALUE(Sheet2[Posting Date],Sheet2[No_],Sheet1[Document No_]),"Posting Description",LOOKUPVALUE(Sheet2[Posting Description],Sheet2[No_],Sheet1[Document No_]))

     

     

    Regards,

    Xiaoxin Sheng

ankitpatira's avatar
ankitpatira
Icon for Community Champion rankCommunity Champion
9 years ago

Satish_Kumar In power bi desktop go to query editor (Edit Queries) and under Transform tab use Group By. May be easier to do it this way.

 

Satish_Kumar's avatar
Satish_Kumar
Icon for Helper V rankHelper V
9 years ago

but the impact was not shown in the view .

 

  • Satish_Kumar's avatar
    Satish_Kumar
    Icon for Helper V rankHelper V
    9 years ago

    And if you share your knowledge to join two table and convert into one comman table.