@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:
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.
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.
@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.
Find out who's part of the program this season, and welcome the new Super Users.
We're excited to announce our first cross-community 'Can You Solve These?' challenge!
Learn about the exciting things that happened in July.
All Data Stories Gallery contributions are reviewed for each month. We select a contribution and feature the community member the following month.
Learn how to develop custom web applications for Power BI using .NET Core 3.1 and .NET 5.