I have problems creating the appropriate relationship and consequently cannot display my data as I want to.
I have the following tables with lots of data created from csv. It is very hard to alter these files as they come in ready.
table 1 Calendar table: full-Date, day, month, year, ...
table 2 Incoming Flights: full-Date, Airline-code, representative-code, ...
table 3 passengers: full-Date, Airline-code, NumberofPassengers, ...
table 4 Airlines: Airline-code, AirlineName, ...
table 5 Representatives: representative-code, FullName, ...
The Question is how and what kind of relationships and or measures I need to create in order to be able to create a pivot table with the following data:
also slicer with year and months are present to select desired period.
<tbody>
</tbody>
all tables have also additional info not related to this problem
full-Date = dd/mm/yyyy
the representative can change on a daily basis (can do several different airlines per day and they are not bound to any specific Airline BUT they do all flights from a specific airline on a particular day).
the Incoming flights table can have several entries per day of the same airline-code according to certain specifics.
Any help would be greatly appreciated
I have the following tables with lots of data created from csv. It is very hard to alter these files as they come in ready.
table 1 Calendar table: full-Date, day, month, year, ...
table 2 Incoming Flights: full-Date, Airline-code, representative-code, ...
table 3 passengers: full-Date, Airline-code, NumberofPassengers, ...
table 4 Airlines: Airline-code, AirlineName, ...
table 5 Representatives: representative-code, FullName, ...
The Question is how and what kind of relationships and or measures I need to create in order to be able to create a pivot table with the following data:
also slicer with year and months are present to select desired period.
Representative Full name | |
Airline Name | Total number of passengers |
<tbody>
</tbody>
all tables have also additional info not related to this problem
full-Date = dd/mm/yyyy
the representative can change on a daily basis (can do several different airlines per day and they are not bound to any specific Airline BUT they do all flights from a specific airline on a particular day).
the Incoming flights table can have several entries per day of the same airline-code according to certain specifics.
Any help would be greatly appreciated