Forum Discussion
Create a Table that includes all data.
Hi,
depending you are summarizing balance you need to check "Show items with no data"
If this post is useful to help you to solve your issue consider giving the post a thumbs up
and accepting it as a solution !
The simplest idea is to create relatianship between thoose table a "Store name" column link. Create table and drag columns in one table on dashboard.
Second idea is to merge queries in Power query as column "Store name" to use as shared link between them
When creating the table and dragging the columns, the rows that do not have data do not appear
Open model window and take a screenshot of created relationship. Check what columns are linked together
The relationship is correc
I need that in this table, the stores that did not count on 10/01 and 10/02, appear anyway
