Earn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.
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.
Solved! Go to 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.
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.
Ashish, Do you know Is there any way to do this within the power query?
Hi,
No. Not an efficient way.
Thank you!
You are welcome.