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 ...
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.