Forum Discussion
Data Modeling Question
Hello, I need advice with a data modeling problem. Below you may find 3 screenshots and attached PBIX file. Link to Download PBIX file Screenshots below show: What my report looks like The...
I was able to figure out this problem on my own. In order to take care of hierarchy between geographical dimension tables (State/County/City) all I had to do was to create Location table with nullable Foreign Keys. See below screenshot.
I was able to figure out this problem on my own. In order to take care of hierarchy between geographical dimension tables (State/County/City) all I had to do was to create Location table with nullable Foreign Keys. See below screenshot.