Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
4 years ago

Data not showing up

Hey Guys, 

 

I'm using 2 DB,

The 1º one have all itens i have in store, and the shortage date. 

The 2º one is linked with the carrier DB, which shows me my invoice, the status (in transit or arrived) and the estimated time of arrival.

 

Some of my itens isn't in transit yet since my shortage is far in the future, so it doens't have row whith the name o this iten, neither a status. 

 

What is happening is: when i put this 2 db in a single visual, it's show only the itens that have a status from my 2º db, i need it to show all itens even if it's not in transit yet. 

 

Do anyone knows how to fix it?

Need Help

2 Replies

  • speedramps's avatar
    speedramps
    Icon for Super User rankSuper User
    4 years ago

    Ok to you have a Stock file (with products currently in warehouse)
    and a Receipts file (with products in various states of arrival).

    But if you want to be good at Power BI then you must not be constrained with how data is input because you can shape it to something better in Power Query,

     

    Recommend you do some video learning about star schema data modelling.

     

    Then create a model with

    Calendar

    Products

    Stock

    Receipts

     

    Then any relationship and measure you need for your reports