Forum Discussion
Assistance with PQE and visuals
I resolved this by adding a dax measure to both of my fact tables and now it works splendidly. Feel free to mark this resolved.
My product code table includes the code, description, division, franchise, business unit, and legal manufacturer. Additionally, the two Excel sheets that I linked to the product code table via the ProductIndex will bring in deliverable dates related to the product codes. I also want to bring in a risk classification for each product code.
So in summary:
- I have one product code table containing the core product details.
- Two additional sheets provide deliverable dates for specific product codes.
- One of those sheets also includes the risk classification for certain codes.
I hope this clarifies things rather than making them more confusing.
Super UserHi nprevallet ,
In this case you have several dates for each product code and also several risk classifications is that it? And you want to bring each line of the two tables into a single visual.
Yes, exactly. Each spreadsheet corresponds to a project which contains product codes and a deliverable date. One of the sheets also has a risk classification which corresponds to a product code. I want to bring the deliverable dates and risk classification into 1 visual, and that visual also will contain details of the product codes being pulled from salesforce.