Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!

Reply
BrunoNM
New Member

Create a Table that includes all data.

Hi All,

 

I need to create a table where it brings the information from table 1 and table 2 in a single table and I don't know the best way to do it.

Store NameCityOpening Date
Store 1São Paulo01/01/2015
Store 2Rio de Janeiro05/05/2016
Store 3Bahia06/06/2017
Store 4Porto Alegre08/08/2018
Store 5Brasília09/09/2019
Store 6Manaus10/09/2019
Store 7Santa Catarina11/09/2019
Store 8Fortaleza12/09/2019
Store 9Belo Horizonte13/09/2019
Store 10Mato Grosso14/09/2019
   

Table 1, I have the name of the stores and information.

 

Store NameDate InventoryNº InvetoryBalance
Store 101/10/202210543213
Store 301/10/202211123452
Store 501/10/202212753242
Store 701/10/202251398755
Store 1001/10/202287542199
    

Table 2 has if the store did the inventory count and the day, if the store did not count it, it does not appear in this table that is generated daily.

 

These tables are related by the Store Name column

 

I need to create this table in power bi where it brings the total list of stores and information where there is a count and the store that did not count, it brings it blank or informing that it did not count.

 

Store NameDate InventoryNº InvetoryBalance
Store 101/10/202210543213
Store 2   
Store 301/10/202211123452
Store 4   
Store 501/10/202212753242
Store 6   
Store 701/10/202251398755
Store 8   
Store 9   
Store 1001/10/202287542199
    

Thanks

1 ACCEPTED SOLUTION

Hi,

depending you are summarizing balance you need to check "Show items with no data"

serpiva64_0-1664891695791.png

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 !

 

View solution in original post

8 REPLIES 8
serpiva64
Super User
Super User

Hi,

please post the data and not the image. It's easier to create the solution. 

Anonymous
Not applicable

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

Anonymous
Not applicable

Open model window and take a screenshot of created relationship. Check what columns are linked together

The relationship is correc
BrunoNM_0-1664888600851.png

 

I need that in this table, the stores that did not count on 10/01 and 10/02, appear anyway

BrunoNM_1-1664888649482.png

 

Hi,

depending you are summarizing balance you need to check "Show items with no data"

serpiva64_0-1664891695791.png

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 !

 

Anonymous
Not applicable

You dragged "date" column to table from third table with unknown data and linked relation. What is the purpose of it if you want in your table "Date of inventory"?

 

 

I used the column "Date" because it is in a calendar table, but if I drag a column "Date Inventary" the view continues to show only the counted days and I need it to show store, date even if there was no count.

Helpful resources

Announcements
April AMA free

Microsoft Fabric AMA Livestream

Join us Tuesday, April 09, 9:00 – 10:00 AM PST for a live, expert-led Q&A session on all things Microsoft Fabric!

March Fabric Community Update

Fabric Community Update - March 2024

Find out what's new and trending in the Fabric Community.