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.

amitchandak's avatar
amitchandak
Icon for Super User rankSuper User
5 years ago

aishak12 , Create a new column in Budget

maxx(filter(Actual, Actual[period] = budget[period]),actual[month pass])

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

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?