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 v-qiuyu-msft

 

I have changed the relationship between clients tables from "Both" to "Single" for Cross filter direction and it solved my problem.

thank you for the usefull link to the theory material.

 

Kind regards,

Katerina

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

Hi Katerina_Bis,

 

It seems the issue was solved. If that is a case, would you please mark a help reply as an answer so that we can close the thread?

 

Best Regards,
Qiuyun Yu