Create new column based on relationship in another SQL View

[aishak12]

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

[Syndicate_Admin]

Don't @aishak12,

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.

[Syndicate_Admin]

Don't @aishak12,

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.

[Syndicate_Admin]

Don't @aishak12,

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.

[Syndicate_Admin]

Don't @aishak12,

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.

[Syndicate_Admin]

Don't @aishak12,

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.

[Syndicate_Admin]

Don't @aishak12,

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.

[Syndicate_Admin]

Don't @aishak12,

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.

[Syndicate_Admin]

Don't @aishak12,

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.

[Syndicate_Admin]

Don't @aishak12,

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.

[Syndicate_Admin]

Don't @aishak12,

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.

[Syndicate_Admin]

Don't @aishak12,

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.

[Syndicate_Admin]

Don't @aishak12,

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.

[Syndicate_Admin]

Don't @aishak12,

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.

[Syndicate_Admin]

Don't @aishak12,

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.

[Syndicate_Admin]

Don't @aishak12,

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.

[Syndicate_Admin]

Don't @aishak12,

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.

[Syndicate_Admin]

Don't @aishak12,

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.

[Syndicate_Admin]

Don't @aishak12,

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.

[Syndicate_Admin]

Don't @aishak12,

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.

[v-henryk-mstf · Accepted solution]

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.