Forum Discussion
One slicer, two date fields
There seem to be a couple of posts similar to this question but not one that fits my situation exactly. I am tracking receipts and dispatches of items. The receipt date is recorded in the Items tab...
IntaBruce, If the case table is capable of serving as the master for the other two tables, proceed with that approach. Otherwise, generate a table containing only the shared case IDs. Integrate a date table and join these two Dispatch_Table and Items_Table tables.
Following this, you can create visuals incorporating case IDs and dates from the master tables, utilizing measures from both the Dispatch_Table and Items_Table.
Power BI- DAX: When I asked you to create common tables: https://youtu.be/a2CrqCA9geM
https://medium.com/@amitchandak/power-bi-when-i-asked-you-to-create-common-tables-a-quick-dax-solution-8e3eccb41bda