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
Icon for Community Support rankCommunity 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

  • 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
      Icon for Community Support rankCommunity 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