Forum Discussion

sagdec12's avatar
sagdec12
Icon for Microsoft Employee rankMicrosoft Employee
4 years ago
Solved

can Power BI create new column with aggregation based on groups?

Hi all, I have a question about the groupby/summarizecolumns question. I understand that we can perform groupby to new table. Suppose I have a table but I want the sum value to be added to the curren...
Need Help
  • amitchandak's avatar
    amitchandak
    4 years ago

    sagdec12 , A new column

     

    Column 3=  sumx(filter(Table, [Column1] = earlier([Column1]) ), [Column 2])

amitchandak's avatar
amitchandak
Icon for Super User rankSuper User
4 years ago

sagdec12 , A new column

 

Column 3=  sumx(filter(Table, [Column1] = earlier([Column1]) ), [Column 2])

  • sagdec12's avatar
    sagdec12
    Icon for Microsoft Employee rankMicrosoft Employee
    4 years ago

    thanks a lot!