Forum Discussion
Matrix with dynamic rows?
I've got a very small dataset (too small to post 😊) that contains just 3 tables: Vehicles which contains two columns: Vehicle No. & Standard Department Vehicle Standard Department DTR-465 ...
Refer to the table,
| Vehicle | From | Till | Appointed Department |
| DTR-465 | 01/01/2020 | 31/01/2020 | ACE-ATT |
| DTR-465 | 01/02/2020 | 28/02/2020 | IBERICA |
| DTR-470 | 01/01/2020 | COIL-ACE |
Here vehicle no DTR-465 is appointed to IBERICA department during the period from 01/02/2020 to 28/02/2020. Then why is vehicle no. DTR-465 appearing in department "COIL-ACE" in your example when the selected date is 03/02/2020?
I need clarification on this to arrive at the logic. Because when I tried the solution, following are the outputs I am getting in Power BI with date selections 30/01/2020 and 03/02/2020.
You are totaly correct, my deepest apologies. 😱
It should appear on the IBERICA department indeed.