cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Highlighted
Super User VII
Super User VII

Re: Managing Relationships

@mrainey can you share the data as mentioned previously? 






Did I answer your question? Mark my post as a solution.

Proud to be a Super User! Appreciate your Kudos 🙂
Feel free to email me with any of your BI needs.





Highlighted
Post Prodigy
Post Prodigy

Re: Managing Relationships

@parry2k I'm not sure how it's going to work since pieces of it is connected to our SQL DB. But here is the link:

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

 

The datasets I'm working with are 'Cservice' and 'EMS Survey' and the fields from each that I would like to connect on (if possible) are 'co' from Cservice and 'New Id' from EMS Survey.

Highlighted
Super User V
Super User V

Re: Managing Relationships

Hi,

 

That link takes me to a page which says that i need permission.


Regards,
Ashish Mathur
http://www.ashishmathur.com
https://www.linkedin.com/in/excelenthusiasts/
Highlighted
Post Prodigy
Post Prodigy

Re: Managing Relationships

@parry2k @Ashish_Mathur I figured that's what it would do. I am not sure how to share this data with you guys because I'm pretty sure I can't hand out company credentials.

Highlighted
Super User VII
Super User VII

Re: Managing Relationships

@mrainey first and foremost we are unable to download the file as @Ashish_Mathur .

 

Easiest way is to pull sample data from SQL in excel sheet and send that over, it will be much easier that way. You can always send private message with the link if you are not comfortable sharing on the forun. Make sure remove any sensitive information.






Did I answer your question? Mark my post as a solution.

Proud to be a Super User! Appreciate your Kudos 🙂
Feel free to email me with any of your BI needs.





Highlighted
Post Prodigy
Post Prodigy

Re: Managing Relationships

@parry2k @Ashish_Mathur  After more trial and error I believe I've figured out the solution to my own problem. I basically had to create another unique ID by merging 2 different columns. After that I was able to join the 2 tables I've been wanting to join and have been able to create the necessary formulas. Thank you both for standing by and being very responsive to my issues.

Highlighted
Super User VII
Super User VII

Re: Managing Relationships

Glad to hear you found the solution, feel free to reach out anytime for another issue/help.

 

Cheers!!

P






Did I answer your question? Mark my post as a solution.

Proud to be a Super User! Appreciate your Kudos 🙂
Feel free to email me with any of your BI needs.





Helpful resources

Announcements
Meet the 2020 Season 2 Power BI Super Users!

Meet the 2020 Season 2 Power BI Super Users!

Find out who's part of the program this season, and welcome the new Super Users.

August 2020 Community Challenge: Can You Solve These?

August 2020 Community Challenge: Can You Solve These?

We're excited to announce our first cross-community 'Can You Solve These?' challenge!

July 2020 Community Highlights

July 2020 Community Highlights

Learn about the exciting things that happened in July.

Featured Data Story of The Month

Featured Data Story of The Month

All Data Stories Gallery contributions are reviewed for each month. We select a contribution and feature the community member the following month.

Power BI Dev Camp - Developing with .NET Core

Power BI Dev Camp - Developing with .NET Core

Learn how to develop custom web applications for Power BI using .NET Core 3.1 and .NET 5.

Top Solution Authors
Top Kudoed Authors