I need to create a fact table in my model based on 2 dimension tables. I used CROSSJOIN function and create table as below.
The problem is I cannot link it to the source dimension tables now, because it creates circular dependency error. Is there any solution for this?
Solved! Go to Solution.
Hi @KamilSzpyrka ,
Has your problem been solved by @DataInsights's solution?
If so, Would you mind accept his reply as solution? Then we are able to close the thread. More people who have the same requirement will find the solution quickly and benefit here. Thank you.
Community Support Team _ kalyj
Click here to learn more about the September 2022 updates!
Watch the playback when Priya Sathy and Charles Webb discuss Datamarts! Kelly also shares Power BI Community updates.
Watch Session 25 of Ted's Dev Camp.