Forum Discussion
Merging 2 Tables
Hello, I am new to Power BI and I am starting to learn its ways... I have what maybe a basic question but after searching I have not been able to fin the answer: I have two tables that I want...
This can be done, but it may not be optimal. Power BI allows you to keep the detail in your data model (Ie day level data) and still create a report like you have shown (by month). This has the benefit of allowing further analysis, like day level patterns etc. Also your design is "unpivoting data" into multiple columns, and this also is probably not optimum.
My knowledge base has info about data shape and calendar tables - both which are part of a good data model design.
http://exceleratorbi.com.au/the-optimal-shape-for-power-pivot-data/
It may be worth reading up before you start to understand good practices. Hope that helps.