Forum Discussion

dplandry's avatar
dplandry
Regular Visitor
9 years ago

Working with dates from multiple tables

Ok, I'm new to Power BI and am really having difficulty getting this report to work.  I have 2 tables...CUSTORDR and AR_INTRASTAT.  I'm trying to build an on-time delivery report and have the main re...
Need Help
Greg_Deckler's avatar
Greg_Deckler
Community Champion
9 years ago

I'm not sure how you get there with the information that you have provided. How does AR_INSTRASTAT relate to CUSTORDR? What ties a customer order to a shipment?

dplandry's avatar
dplandry
Regular Visitor
9 years ago

Sorry I left that out of my post..  They're joined by SALESORDER# which appears in both tables.

  • v-ljerr-msft's avatar
    v-ljerr-msft
    Microsoft Employee
    9 years ago

    Hi dplandry,

     

    Could you post your table structures with some sample data in this case? It's better to share a sample pbix file.:smileyhappy:

     

    Regards