Forum Discussion
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: Cal...
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
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 🙂