Forum Discussion
Create a Relationship Error
- Anonymous1 year ago
Thanks for az38's concern about this issue.
Hi, guybrit
I am glad to help you.
According to the problem you described, first you need to connect Power BI to different data source and then open Power Query Editor:
Select one of the tables and click Append Queries as New, then select the corresponding two tables and you will get a new table:
Ctrl+click Base Points and Bonus Points, right click and select Replace value, replace null with 0:
Close&Reply.
New measure in the new table:Total Points(Base + Bonus) = SUMX ( AppendTable, AppendTable[Base Points] + AppendTable[Bonus Points] )I hope my suggestions give you good ideas, if you have any more questions, please clarify in a follow-up reply.
Best Regards,
Fen Ling,
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Thanks for az38's concern about this issue.
Hi, guybrit
I am glad to help you.
According to the problem you described, first you need to connect Power BI to different data source and then open Power Query Editor:
Select one of the tables and click Append Queries as New, then select the corresponding two tables and you will get a new table:
Ctrl+click Base Points and Bonus Points, right click and select Replace value, replace null with 0:
Close&Reply.
New measure in the new table:
Total Points(Base + Bonus) =
SUMX ( AppendTable, AppendTable[Base Points] + AppendTable[Bonus Points] )
I hope my suggestions give you good ideas, if you have any more questions, please clarify in a follow-up reply.
Best Regards,
Fen Ling,
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.