Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
5 years ago

Multiple Date columns in matrix

Right here is my sample data. 

 

Name  Area              KPI1             KPI1 Date      KPI2              KPI2 Date

a London Completed 11/03/2021 Completed 01/03/2021
b Manchester   25/02/2021 Completed 01/03/2021
c Chester Completed 01/03/2021 Completed 11/03/2021
d Leeds   25/02/2021   03/02/2021
e London Completed 01/03/2021   03/02/2021
f Chester Completed 11/03/2021 Completed 12/02/2021
g Leeds Completed 11/03/2021 Completed 12/03/2021
h Glasglow   01/01/2021 Completed 05/01/2021

 

Without creating multiple tables for each KPI, I need to find a solution that will allow me to filter the count of KPI's completed by their corresponding date. For example: If I filter the highlighted below KPI 1 date for all outputs before the 11th of Match, I don't want to lose KPI2 output or vice versa. 

 

I can achieve this by creating multiple tables for each KPI but it's not a great solution for me. 

 

Any advice would be appreciated. 

 

 

Karlos. 

 

 




2 Replies

  • AnkitKukreja's avatar
    AnkitKukreja
    Icon for Super User rankSuper User
    5 years ago

    Hi Anonymous ,

    You can use date table in your model and have a direct active with KPI1 date and inactive relationship with KPI2 date.

    Then use slicer as date from your date table (it's a must for PBI model). Then just create 2 measures where you can count KPI1 and KPI2.

     

    Thanks,

    Ankit

    • Anonymous's avatar
      Anonymous
      Not applicable
      5 years ago

      Hey Thanks for the reply, 

      That's actually the direction I've taken it, however, because both measures are in the same table, once I slice either KPI1 by KPI 1 date it will alter KPI 2 and vice versa. It would be fine if I had the measures outside of the same table but for the solution, I'm working with, that's not possible.