Grouping in Table

[Anonymous]

Hi Expert,

How Can I grouping a table, table value, let's say I have items code which are repeating but I want to club it, i dob't want it should repeat nor it's value, and i want to do it on Table not on matrix

rgrds,

Arif

[amitchandak]

@Anonymous , In a visual table, if you take summarized columns along with not summarized columns then you will get only one value summarized columns (set)

You can create new table using group by in power query or summarize in dax

https://radacad.com/power-bi-aggregation-step-1-create-the-aggregated-table