Forum Discussion
Create new column based on relationship in another SQL View
Hello,
I have two SQL views one for Actual and the other is Budgeting data. These views both contain a column Period with data from 2020 01 - 2021 12.
In the SQL View (Actual) I have a column for MonthPassed that is 1 or 0 based on the Period. I want to add this column to the Budgeting view in PowerBI.
For example if Period (202001) = MonthPassed (1) it should have the same relationship in the Budgeting view.
Actual:
Budgeting
Is this possible to add in PowerBI if so how should I approach this for the relationship to reflect the same values.
Thank you
Hi aishak12 ,
I think it is possible. I did the following test and created two tables. The Period and Monthpass fields are from different tables. In powerbi query, I only need to add the same index to the two tables respectively, and then merge into one table according to the index, and finally get the budget table successfully.
get Budgeting result
If the problem is still not resolved, please provide detailed error information and let me know immediately. Looking forward to your reply.
Best Regards,
Henry
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
22 Replies
aishak12 , Create a new column in Budget
maxx(filter(Actual, Actual[period] = budget[period]),actual[month pass])
Thank you, Is there a way to do this in Power Query so I can use this as the first step right after sourcing the data?
Hi aishak12 ,
I think it is possible. I did the following test and created two tables. The Period and Monthpass fields are from different tables. In powerbi query, I only need to add the same index to the two tables respectively, and then merge into one table according to the index, and finally get the budget table successfully.
get Budgeting result
If the problem is still not resolved, please provide detailed error information and let me know immediately. Looking forward to your reply.
Best Regards,
Henry
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.I think it's possible. I did the next test and created two boards. The Period and Month Step fields come from different tables. In the powerbi query, I just need to add the same index to the two tables respectively, and then merge into a table based on the index, and finally get the budget table correctly.
get budgeting result
If the issue has not yet been resolved, provide detailed error information and let me know immediately. We look forward to your response.
Best regards
henry
If this post helps,then consider Accepting it as the solution to help other members find it faster.I think it's possible. I did the next test and created two boards. The Period and month step fields come from different tables. In the powerbi query, I just need to add the same index to the two tables respectively, and then merge into an index-based table and finally get the budget table correctly.
get budgeting result
If the issue has not yet been resolved, provide detailed error information and let me know immediately. We look forward to your response.
Best regards
henry
If this post helps, consider Accepting it as the solution to help other members find it faster.I think it's possible. I did the next test and created two boards. The period and month step-by-step fields come from different tables. In the powerbi query, I just need to add the same index to the two tables respectively, and then merge into an index-based table and finally get the budget table correctly.
get budgeting result
If the issue has not yet been resolved, provide detailed error information and let me know immediately. We look forward to your response.
Best regards
henry
If this post helps, consider Accepting it as the solution to help other members find it faster.I think it's possible. I did the next test and created two boards. Point-by-month fields come from different tables. In the powerbi query, I just need to add the same index to the two tables respectively, and then merge into an index-based table and finally get the budget table correctly.
get budgeting result
If the issue has not yet been resolved, provide detailed error information and let me know immediately. We look forward to your response.
Best regards
henry
If this post helps, consider Accepting it as the solution to help other members find it faster.I think it's possible. I did the next test and created two boards. Point-to-month fields come from different tables. In the powerbi query, I just need to add the same index to the two tables respectively, and then merge into an index-based table and finally get the budget table correctly.
get budgeting result
If the issue has not yet been resolved, provide detailed error information and let me know immediately. We look forward to your response.
Best regards
henry
If this post helps, consider Accepting it as the solution to help other members find it faster.I think it's possible. I did the next test and created two boards. Point-to-month fields come from different tables. In the powerbi query, I just need to add the same index to the two tables respectively, and then merge into an index-based table and finally get the budget table correctly.
get budgeting result
If the issue has not yet been resolved, provide detailed error information and let me know immediately. We look forward to your response.
Best regards
henry
If this post helps, consider Accepting it as the solution to help other members find it faster.I think it's possible. I did the next test and created two boards. Point-to-month fields come from different tables. In the powerbi query, I just need to add the same index to the two tables respectively, and then merge into an index-based table and finally get the budget table correctly.
get budgeting result
If the issue has not yet been resolved, provide detailed error information and let me know immediately. We look forward to your response.
Best regards
henry
If this post helps, consider Accepting it as the solution to help other members find it faster.I think it's possible. I did the next test and created two boards. Point-to-month fields come from different tables. In the powerbi query, I just need to add the same index to the two tables respectively, and then merge into an index-based table and finally get the budget table correctly.
get budgeting result
If the issue has not yet been resolved, provide detailed error information and let me know immediately. We look forward to your response.
Best regards
henry
If this post helps, consider Accepting it as the solution to help other members find it faster.
