Forum Discussion
Help with table relationships, several tables per year
Probably the best approach is to add a "Year" column to each of your 5 tables with the appropriate value, then do an Append Merge operation to append all 5 tables into 1 table (you would then turn off data loading for the 5 original tables to avoid loading all the data twice), then it would be much easier to write generic measures that will do comparisons across the various years.
Hi Anonymous ,
You can create new calculated table using DAX below.
Table = UNION(ADDCOLUMNS('2015',"Year","2015"),ADDCOLUMNS('2016',"Year","2016"))
Best Regards,
Amy
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Community SupportHi Anonymous ,
You can create new calculated table using DAX below.
Table = UNION(ADDCOLUMNS('2015',"Year","2015"),ADDCOLUMNS('2016',"Year","2016"))
Best Regards,
Amy
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
- d_gosbell
Super User
v-xicai wrote:Hi Anonymous ,
You can create new calculated table using DAX below.
Table = UNION(ADDCOLUMNS('2015',"Year","2015"),ADDCOLUMNS('2016',"Year","2016"))
You can do that. But then you have all the data loaded into memory twice. It's a better practice to do the unioning in Power Query and only have one copy loaded into memory.