Forum Discussion

LD's avatar
LD
Frequent Visitor
5 years ago
Solved

Help on Power KPI Matrix

Dear All,   Please, I'm building a new Table for Power KPI Matrix (Call Table KPI Matrix), and I'm taking the data from another table (Call Table Raw Data). My problem, now, is to duplicate the Da...
Need Help
  • amitchandak's avatar
    amitchandak
    5 years ago

    LD , Try a new table like

    crossjoin(Distinct(Table[Date]),distinct(Table[category]))

amitchandak's avatar
amitchandak
Super User
5 years ago

LD , Try a new table like

crossjoin(Distinct(Table[Date]),distinct(Table[category]))