Forum Discussion

craig811's avatar
craig811
Icon for Helper III rankHelper III
7 years ago
Solved

Power Query - Linking two Queries

Hi ,   I am new to power query and I am trying to understand how I can create a new colum in my query 'Main Data'  using the 'Period' coulmn in my query 'Monthly Finance Periods' .   I want to cr...
Interesting Links
Need Help
Tips and Tricks
  • v-xicai's avatar
    v-xicai
    7 years ago

    Hi craig811 ,

     

    You can try to create a calculated column in table 'Main Data' using DAX below.

     

    Column 1= CALCULATE(VALUES('Monthly Finance Periods'[Period]),FILTER('Monthly Finance Periods', 'Main Data'[Transaction date]<'Monthly Finance Periods'[End Date] && 'Main Data' '[Transaction date]>'Monthly Finance Periods'[Start Date]))

     

    Best Regards,

    Amy

     

    If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

     

v-xicai's avatar
v-xicai
Icon for Community Support rankCommunity Support
7 years ago

Hi craig811 ,

 

You can try to create a calculated column in table 'Main Data' using DAX below.

 

Column 1= CALCULATE(VALUES('Monthly Finance Periods'[Period]),FILTER('Monthly Finance Periods', 'Main Data'[Transaction date]<'Monthly Finance Periods'[End Date] && 'Main Data' '[Transaction date]>'Monthly Finance Periods'[Start Date]))

 

Best Regards,

Amy

 

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.