Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Earn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.

Reply
Chandramouli_BI
Helper III
Helper III

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.

 

Chandramouli_BI_0-1702449050807.png

 

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 

 

 

2 REPLIES 2
PijushRoy
Super User
Super User

Hi @Chandramouli_BI 

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

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

Helpful resources

Announcements
RTI Forums Carousel3

New forum boards available in Real-Time Intelligence.

Ask questions in Eventhouse and KQL, Eventstream, and Reflex.

MayPowerBICarousel

Power BI Monthly Update - May 2024

Check out the May 2024 Power BI update to learn about new features.

LearnSurvey

Fabric certifications survey

Certification feedback opportunity for the community.