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
Ashish_Mathur's avatar
Ashish_Mathur
Super User
6 years ago

Hi,

I do not understand your question.  Vehicles DTR-466,467,468 and 469 have no record at all in the second table.  Therefore, when one selects the date as 30/1/2020, why should these appear in the final result?

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.