Forum Discussion

hama21's avatar
hama21
Icon for Helper I rankHelper I
2 years ago
Solved

Dealing with Ambiguous Relationships and Multiple Granularity in Power BI

Hi everyone, I'm currently facing a challenge in Power BI and would appreciate some advice from the community. I have three tables in my dataset: Table A: Contains monthly records of each client'...
Need Help
Tips and Tricks
  • Fthrs_Analytics's avatar
    Fthrs_Analytics
    2 years ago

    I think you need an Advisor dimension in your data model to relate to Table A and Table B (like the date dimension does). I've attached an example .pbix file here.

Fthrs_Analytics's avatar
Fthrs_Analytics
Frequent Visitor
2 years ago

I think you need an Advisor dimension in your data model to relate to Table A and Table B (like the date dimension does). I've attached an example .pbix file here.