Forum Discussion

aishak12's avatar
aishak12
Icon for Helper IV rankHelper IV
5 years ago
Solved

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...
Need Help
  • v-henryk-mstf's avatar
    v-henryk-mstf
    5 years ago

    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.

Syndicate_Admin's avatar
Syndicate_Admin
Icon for Administrator rankAdministrator
5 years ago

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.

v-henryk-mstf_0-1617700613319.pngv-henryk-mstf_1-1617700632136.png

v-henryk-mstf_2-1617700857181.png

get budgeting result

v-henryk-mstf_3-1617700923116.png


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.