Forum Discussion
Database structure - create relationships
Dear all, I'm quite new in the Power BI. We use a sort of ERP and power BI is linked to it. I can see the databases and it seems that in order to create proper relationships I might have to change a bit the structure.
Indeed it looks like this:
This table is then linked to another one through the FirmenID that returns the names, etc.
The column "PHKeys" refers to attributes in the ERP and it's quite difficule to then create relationships between them.
I tried to duplicate the table into small ones, but then the relationship doesn't seems to work between the duplicates.
And I'm not even mentionning the dates!
Any idea?
5 Replies
According to your description, it seems not too duplicated. A relationship based on my understanding would be like
Hi,
Thanks for your feedback, then how can I search and get info from the DB with more than 1 criteria ?
Indeed I would need the date > than a date to be selected in a slicer + a certain value from the PHKey to return a value from the Content column?
As long as the relationship is set up properly, you can use 2 slicers, one for Dim_Date[date] and another for Attributes[PHKEY]. They two cooperate to fliter the data. There exists interactions amont visuals.
