How to create Consolidation Reports

Hi dheeraj_ami,

Yes, it is possible. I’d like to suggest you add a column as group, then you could use this column to grouping the data.

For example:

Type is the group column, if your data source doesn’t exist the group column, you could use calculate column to instead.

Result:

Regards,

Xiaoxin Sheng

Hi dheeraj_ami,

If your data source has related table about the group type, you could use RELATED function or lookup value function to add the group column.

If your data doesn’t exist group column, you could try to use if function or switch function to add the column. (you could refer to my earlier reply)

Sample (I want to set tom, jerry to a same group A, other to B):

Type=If ( or('Sales Record'[Custom Name]="Tom",'Sales Record'[Custom Name]="jerry "),"A","B")

Type=SWITCH ('Sales Record'[Custom Name],"Tom","A","jerry","A","B")

Regards,

Xiaoxin Sheng