Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
1 year ago

Datum table link

Good morning. I can't connect my datum table with a table that I created. Can you help me? THANKS. Here is a screenshot:    
Need Help
Smalfly's avatar
Smalfly
Responsive Resident
1 year ago

Hi Anonymous ,

 

You are trying to create a direct relation between the tables Datum and Objectifs Promoteurs.

But there already exists an indirect relation between those 2 tables (through the links between the tables clients, Objectifs promoteurs, Datum and Vente). This is technically not possible in Power BI.

 

However, how you should tackle this, depends on the contents of your data model and what you are willing to achieve in your report. Can you share your data model set-up and some example data? That would make it easier to help you.

  • Anonymous's avatar
    Anonymous
    Not applicable
    1 year ago

    Hello, sorry for my late response but I was on vacation. I managed to connect the tables but the result does not suit me. I am looking to know the promoters objective per month. Here are the connections and here is the result obtained which is not correct. Indeed, in the “Sum of Objective 2024” column, the annual amount is displayed and does not take months into account. Can you help me? THANKS