Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
2 years ago

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:

 

https://docs.google.com/spreadsheets/d/1cZkc7pBvOHL9CrKCo1uUaJGBr05Ub8ge/edit?usp=sharing&ouid=108100635835723086697&rtpof=true&sd=true 

 

Pbix File Link:

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

 

 

2 Replies

  • PijushRoy's avatar
    PijushRoy
    Community Champion

    Hi Anonymous 

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

    • Anonymous's avatar
      Anonymous
      Not applicable

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