I am trying to generate a report wherein I need to get the following view
The Date Filter is the Date Dimension
Here is what the model looks like.. but without relationships.
How can I relate the tables, such that the report then filters out the other measures like Delivery Costs and Order Qty for the selected Date from the date dimension?
Any help would be appreciated.. I am also trying here.
Go to Solution.
Please try this
What is DlvID in your FactCosts Table???
Can you share your .pbix file? You can upload it to OneDrive or DropBox and post the link here.
Engage and empower students with Power BI!
Continue your learning in our online communities.
Travel to Melbourne and network with thousands of peers!
Check out what's new in the Power BI Community!