Allocate fee in same period

Msoh — Sun, 14 Apr 2024 11:54:00 GMT

I have two tables like this

Table A

Enno Period Fee

1 Jan 2023 100

2 Jan 2023 400

1 Jan 2023 200

3 Mar 2023 400

1 Mar 2023 100

3 Mar 2023 200

Table B

AlocateNo Alocateto Aloperiod AMOUNT

1 2 Jan 2023 100

1 3 Jan 2023 100

Table A - contained Engagement, period and Fee

Table B - contained allocated engagementNo, EngagementNo (that want to alocate to desired engagement ), Alocation period and amounts

For example, If I want to alocate fee from engagementNo 1 to engagementNo 2and 3,which same period as conditions in table B. How can I alocate correctly. I try many way but my data still duplicate in table A.

Re: Allocate fee in same period

Greg_Deckler — Sun, 14 Apr 2024 16:04:58 GMT

Msoh So in the example you have presented, what do you want your output to be? I'm not clear on that.

Re: Allocate fee in same period

Msoh — Mon, 15 Apr 2024 13:46:26 GMT

Thank you for your reply. This is the result I want

topic Allocate fee in same period in DAX Commands and Tips

Allocate fee in same period

Re: Allocate fee in same period

Re: Allocate fee in same period