Forum Discussion
Helper ICalculated column error
Hello Elyblog2009, and thank you for sharing a question with the Community. Please remember to adhere to the decorum of the Community Forum when asking a question.
Please provide your work-in-progress Power BI Desktop file (with sensitive information removed) that covers your issue or question completely in a usable format (not as a screenshot). You can upload the PBIX file to a cloud storage service such as OneDrive, Google Drive, Dropbox, or to a Github repository, and then share a file’s URL.
https://community.fabric.microsoft.com/t5/Community-Blog/How-to-provide-sample-data-in-the-Power-BI-Forum/ba-p/963216
Please show the expected outcome based on the sample data you provided.
https://community.fabric.microsoft.com/t5/Desktop/How-to-Get-Your-Question-Answered-Quickly/m-p/1447523/highlight/true#M607150
This allows members of the Forum to assess the state of the model, report layer, relationships, and any DAX applied.
Community ChampionHi Elyblog2009
2 tables will have only one active relationship. if you want to connect above two tables n try to join from Primary key to foreign key of table . 1 to many relationship.
1st identify primary key whether your product is primary key or portfolio name then join with second table only with product or portfolio name either of 1 not both.
that's it. your model will be ready to use for futher analysis.
Note: If you have accepted the solution of expert it means your post will not be viewed by other solutioner. you have to again post it so other expert will able to answer it.
you have accepted the solution which has not solved your issue. Foodd has given you options how you can upload the pbix file and how to post the question. please follow the guidlines.
I hope I answered your question!