Forum Discussion
filter a dashboard using different Date fields for different visuals.
There are multiple potential ways to traverse relationships between tables in your data model, leading to confusion or incorrect results.
- Order Product Shipment > Order Product > Calendar Dates
- Order Product Shipment > Calendar Dates
Normally, you would want it to be
- Calendar > Order Product Shipment
- Calendar > Order Product
- Order ID > Order Product Shipment
- Order ID > Order Product > Order Details
In here I am assuming Order Product is when the orders were made and Order Product Shipment is another table for shipment.
But then these are just assumptions. You did not provide a sample data. https://community.fabric.microsoft.com/t5/Desktop/How-to-Get-Your-Question-Answered-Quickly/td-p/1447523/
thans I watched some youtube videos on date tables and created one and then created a link to my Opportunity table, my Transaction table, my Shipment table but my Order product table where my schedule ship date is gets an error
There are multiple potential ways to traverse relationships between tables in your data model, leading to confusion or incorrect results.
- Order Product Shipment > Order Product > Calendar Dates
- Order Product Shipment > Calendar Dates
Normally, you would want it to be
- Calendar > Order Product Shipment
- Calendar > Order Product
- Order ID > Order Product Shipment
- Order ID > Order Product > Order Details
In here I am assuming Order Product is when the orders were made and Order Product Shipment is another table for shipment.
But then these are just assumptions. You did not provide a sample data. https://community.fabric.microsoft.com/t5/Desktop/How-to-Get-Your-Question-Answered-Quickly/td-p/1447523/