Custon Column - bring a value the another table based in paramter dates in power query

[Portrek]

Hello guys. I have a question, can you help me.

I want to create a new customized column in the data table (image 1) that brings me the relative values of the Group table, column ID GROUPS, (image2) considering the appropriate parameter of the dates ..

For example: If the date of the data table - (Image 1) is between the start date and the end date of the groups table (Image2) will bring me the value corresponding to the ID_Group of the group column of the data table.

Thank you in advance for your help.

[Ashish_Mathur · Accepted solution]

Hi,

Enter this calculated column formula in DATAS table

=calculate(sum(Group[idgroup]),filter(group,group[group]=earlier(datas[group])&&group([data inicio])<=earlier(datas[data])&&group([data inicio])>=earlier(datas[data])))

Hope this helps.

[Portrek]

Ashish, Do you know Is there any way to do this within the power query?

[Ashish_Mathur]

Hi,

No.  Not an efficient way.

[Portrek]

Thank you!

[Ashish_Mathur]

You are welcome.