Creating Multiple Relationships All At Once

[EvonS]

Hello Everyone,

I have an excel sheet with multiple tabs. All my pivot tables have a Date and Area column while all the other columns are different. I'd like to create relationships between all Area and Date columns across all tables at once. Is this possible? I'd ultimately like to be able to slice my data according to date and area.

Thanks,

 

[Matt Allington]

How many tables and how many columns in each? what Type of data is in the extra columns? Could you unpivot these other columns and then append them all together?

 

[EvonS]

Thanks for responding. Besides the Date and Area columns, there will be at least 4 or 5 additional columns. The columns are either percentage, text or whole numbers. Unfortunately I can't unpivot because of the way my data is set up. I attached a pic so you can see what I mean.

 

[EvonS]

How many tables and how many columns in each? what Type of data is in the extra columns? Could you unpivot these other columns and then append them all together?

I create the pivot tables by using my org's data warehouse. The IT dept. did some programming so that the warehouse can process the information in its current structure in pivot tables in Excel. Unfortunately Power BI isn't compatible with our data warehouse so I can't connect it directly to our data cube.