Help Neede (Urgent)

[Anonymous]

dim_service to dim_route_stage (1 to many via service_key column).  dim_service to agg_route( 1 to many via service_key column). agg_route to agg_route_trip ( 1 to many via Pk column).  agg_route_trip to agg_route_stop ( 1 to many via Trip_stop column).

Now I created a table visual contains cloumns--> service column (dim_service table), stage_seq_no, stage_name columns ( dim_route_stage table), boarding column (agg_route_trip/agg_route_stop table), Epk column (agg_route_trip table) .

I am getting the following output which is wrong. boarding & EPK should be different for each stage_name. Please help me to get the required output.

Sample File Link:

https://docs.google.com/spreadsheets/d/1cZkc7pBvOHL9CrKCo1uUaJGBr05Ub8ge/edit?usp=sharing&ouid=10810... 

Pbix File Link:

https://drive.google.com/file/d/1ydyOHZvhEhqP8Xqnh5c5GV7EgRwAmzWe/view?usp=sharing 

[PijushRoy]

Hi @Anonymous 

Please create a pbix file with mentioned sample data and share the pbix file Google drive link with All Access

[Anonymous]

Hi @PijushRoy Now I have added sample file & Pbix file in the query. Pls resolve this issue. Thanks