Forum Discussion

Katerina_Bis's avatar
Katerina_Bis
Frequent Visitor
9 years ago
Solved

ytd

Hello,   In power BI desktop my problems is that I need to combine 2 different YTD measures (calculated on 2 tables, thus 2 different date tables used too). The program does not allow me to includ...
Need Help
  • v-qiuyu-msft's avatar
    v-qiuyu-msft
    9 years ago

    Hi Katerina_Bis,

     

    When you added measures *YTD_turnover amd *YTD_timelog to a table visual, which error threw out? Please try to set the cross filtering direction to Both for each relationship among those tables. For more information, see: Create and manage relationships in Power BI Desktop.

     

    Best Regards,
    QiuyunYu

Katerina_Bis's avatar
Katerina_Bis
Frequent Visitor
9 years ago

Hello,

 

I cannot share the data sample. But I have drafted the data structure and the desirable result.

Hope it helps.

data_structure

v-qiuyu-msft's avatar
v-qiuyu-msft
Community Support
9 years ago

Hi Katerina_Bis,

 

When you added measures *YTD_turnover amd *YTD_timelog to a table visual, which error threw out? Please try to set the cross filtering direction to Both for each relationship among those tables. For more information, see: Create and manage relationships in Power BI Desktop.

 

Best Regards,
QiuyunYu