Forum Discussion
How to create an input table pivoting field from multiple tables
- 8 years ago
It'd be an awful lot easier if you merged your primary and secondary tables together...
Hello this is the situation:
I have multiple tables based on Type of school:
Primary school TableSecondary school Table
Then I have a table with the Max People Capacity regardless the Type of school
Daily capacity Table
And at the end I have a Calendar Table
Calendar Table
And the tables have these relationships:
Relationships
Moreover I have 2 Measures:
Total no. of People
Tot. no of People = SUM(Primaryschool_Table[No. of People]) + SUM(Secondaryschool_Table[No. of People])
and the Availabilty Measure (Max daily Capacity-Tot. no of People)
Availability Measure =
SUM(DailyCapacity_Table[Daily Max people capacity])
-SUM(Primaryschool_Table[No. of People])
-SUM(Secondaryschool_Table[No. of People])
I need to create an input table with "Date", "City" and the associate "Availability" as follow:
I need it as an input table in the data model, in order to create additional Measures based on it (e.g. Sum all city with Availabilty > 40).
Perhaps I was verbose, but it was necessary to make the picture clear. I thank you all of us who can help me!!! I'm trying to solve this since 2 weeks!
Hi ivandelgra
You can have the sample data for all 4 tables in an excel and attach the file here.
Thanks
Raj