Forum Discussion
Calculated column error
Hello all,
Can please someone help me on the below error? I am new at Power Bi and I am not figuring out where is the issue in the relationship created between the table of the formula itself.
I have 2 table data Main "Customer Profile" and VFAL_Product_Portfogio"
I need to match the "Product" column in Customer Profile with the Product in the VFAL_Product_List with the Product Portofoglio Name and in the Customer Profile tab the column Service to be populated with the Product Porfoglio Name.
I have created this relationship between tables .
Please I need support.
Thank you!
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.
5 Replies
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.Please help me on the error above. Thank you!
This issue is not resolved. Pleased if you can help me?
Hello all,
Can please someone help me with the below error? I am new at Power BI and I am not figuring out where is the issue in the relationship created between the table of the formula itself.
I have 2 table data Main "Customer Profile" and VFAL_Product_Portfogio"
ProductFamily Name
Mobile APN FLEET ProductVFAL_Product_Family
Mobile Mobility APN CLOUD FLEET IoT I need to match the "Product" column in Customer Profile with the Product in the VFAL_Product_List with the Product Portofoglio Name and in the Customer Profile tab the column Service to be populated with the Product Porfoglio Name.
I have created this relationship between tables .
Please I need support.
Thank you!
Hi 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!
