Forum Discussion

pbi1908's avatar
pbi1908
Helper III
3 years ago
Solved

Drill down table with dates

Hi  everyone,  I have 3 tables,  Projects  Tasks and SubTasks   I would like to create a drill down table (matrix) in Power BI in which i will have 3 layers (Projects, Tasks, ...
Need Help
  • v-yalanwu-msft's avatar
    v-yalanwu-msft
    3 years ago

    Hi, pbi1908 ;

    Try to create a measure.

    Measure = 
IF(ISINSCOPE('SubTasks'[SubTask Name]),MAX('SubTasks'[start date]),
IF(ISINSCOPE('Tasks'[Task Name]),MAX('Tasks'[start date]),MAX('Projects'[start date])))

    The final show:


    Best Regards,
    Community Support Team _ Yalan Wu
    If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

v-yalanwu-msft's avatar
v-yalanwu-msft
Community Support
3 years ago

Hi, pbi1908 ;

Try to create a measure.

Measure = 
IF(ISINSCOPE('SubTasks'[SubTask Name]),MAX('SubTasks'[start date]),
IF(ISINSCOPE('Tasks'[Task Name]),MAX('Tasks'[start date]),MAX('Projects'[start date])))

The final show:


Best Regards,
Community Support Team _ Yalan Wu
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.