Forum Discussion

BramSegers's avatar
BramSegers
Frequent Visitor
6 years ago

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 ...
Need Help
BramSegers's avatar
BramSegers
Frequent Visitor
6 years ago

Hi,

Thanks for your reply.

I indeed didn't mention that, but those vehicles should appear date-independant, because they have a registered turnover.

Anonymous's avatar
Anonymous
Not applicable
6 years ago

Refer to the table,

 

VehicleFromTillAppointed Department
DTR-46501/01/202031/01/2020ACE-ATT
DTR-46501/02/202028/02/2020IBERICA
DTR-47001/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.

 

 

 

  • BramSegers's avatar
    BramSegers
    Frequent Visitor
    6 years ago

    You are totaly correct, my deepest apologies. ğŸ˜±

    It should appear on the IBERICA department indeed.