Forum Discussion
Help Neede (Urgent)
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:
Pbix File Link:
https://drive.google.com/file/d/1ydyOHZvhEhqP8Xqnh5c5GV7EgRwAmzWe/view?usp=sharing