Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
3 years ago

data model ambiguity

Hi,

 

For some time I am learning PowerBI and while my knowledge is increasing slowly, I still have issues with creating a new data model relationship 🙂

 

I have the following structure:

 

Calendar : Date Table

2021-2022 : Actuals 2021 - 2022

LE 2021 - 2022 : Latest Estimate 2021 - 2022

Mapping : Mapping per project

 

 

So the PowerBI visualization was working as I had only data for 2021. Now I added in my LE 2021-2022 data for 2022, but somehow I am not able to connect it with the Calendar table in order to filter per YEAR as it creates Ambiguity between Actuals 2021-2022 and Calendar Table. I understand that it creates ambiguity, but I am just not sure on how to solve it... 🙂

 

Any advice?

 

Show and Tell
Tips and Tricks

2 Replies

  • amitchandak's avatar
    amitchandak
    Super User
    3 years ago

    Anonymous , There are two paths to reach from Year to Actuals 2021 - 2022

     

    If mapping is fact it should not join with  Actuals 2021 - 2022

     

    or have fact mapping and merged fact from mapping and Actuals 2021 - 2022

     

    and they should not join with each other

    • Anonymous's avatar
      Anonymous
      Not applicable
      3 years ago

      amitchandak thanks

      I will have a look.

       

      The problem is actually with the LE table. There I have LE per project for different years and I am not sure on how to connect that with my actuals table (should it be merged or via relationship...). It is perhaps difficult to advice if you do not have the full data, but any advice is welcome 🙂