Forum Discussion
Solved
Missing dates - Estimated vs Real Line Chart - Can't find a solution
Hi, there! So I'm new to Power BI and there's this problem I can't seem to find a solution. I have table 1 and table 2. Table 1 contains date and real sales value. Table 2 contains date an...
Hi tgom94 ,
You can create a calendar table with whole date range, then use this as bridge to link two tables.
When you use calendar date field as category fields, it will mapping and summary all records based on relationship.
Regards,Xiaoxin Sheng
Hi tgom94 ,
You can create a calendar table with whole date range, then use this as bridge to link two tables.
When you use calendar date field as category fields, it will mapping and summary all records based on relationship.
Regards,
Xiaoxin Sheng