Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
5 years ago

Use a column with already aggregated values

Hi all, 

 

I have the following two tables (1 and 2).

The values in table 1 are already aggregated (I don't want to aggregated them in power bi).

Is there any way to treat the data in this way? I would like to make a table like table 3, where the aggregated values of regions A and B would use the default values.

Thank you very much

 

1 Reply

  • Anonymous , if values L1 are unique in table two. Then you can join L1 with the region of Table1 and analyze data of table 1 with L0 and L1 of table2