Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!

Reply
pmargarido
New Member

Split amount from start date / end date per type of payment

Hello all

Would like to know if anybody could give some tips/solutions on how could I solve this challenge:

I need to split between start date and end date , by month / trimester / semester or annual, depending on the payment type,  the commission amount.

 

Payment typeDt.StartDt.EndCommision
Month22/04/201906/10/2021€ 317,06
Trimester02/10/201906/10/2021€ 339,52
Semester31/07/201806/10/2021€ 293,27
Month29/05/201806/10/2021€ 388,12
Month20/06/201806/10/2021€ 821,50
Semester01/09/201806/10/2021€ 214,65
Semester01/08/201806/10/2021€ 101,78
Month01/07/201806/10/2021€ 634,45
Month01/01/202106/10/2021€ 166,41
Annual14/09/202006/10/2021€ 118,31
Month15/11/201906/10/2021€ 428,81
Trimester29/06/201806/10/2021€ 63,10
Month20/11/201906/10/2021€ 79,27
Month21/10/202006/10/2021€ 465,84
Month29/10/201806/10/2021€ 372,74
Annual24/06/201906/10/2021€ 901,28
Month16/08/201906/10/2021€ 111,95
Month19/01/202106/10/2021€ 275,91
Month02/07/201906/10/2021€ 390,22
Month27/12/201906/10/2021€ 155,16
Trimester01/12/202006/10/2021€ 80,94
Month01/12/201906/10/2021€ 48,03
Month24/11/202006/10/2021€ 199,00

 

Really appreciate your inputs
KR
Paulo 

6 REPLIES 6
pmargarido
New Member

Hello jppv20,
thanks for your reply
I get the payment of this commissions per payment type also , so I would like to create a control to validate what I',m getting as payment is correct .
Taking as example the first entry :

Payment type

Dt.Start

Dt.End

Commission

Month

22/04/2019

06/10/2021

€ 317,06

 

The Output will be something like :
Split the 317,06 by the difference between dates(year/month)
Accrual on year/month the commision 
After I will be able to check , per year /month, in this case,  what they payed is the same I have accrual.

hope this help.
KR
Paulo



 

 

Hi @pmargarido ,

 

Can you provide a screenshot of the desired output? This will help understand better what you are trying to achieve.

jppv20
Solution Sage
Solution Sage

Hi @pmargarido ,

 

Could you give an example of the desired output? So what you want to achieve?

Hello jppv20,
Will be somehting like this.


pmargarido_0-1633512040959.png

This figure shows the amount acumulated on the Start date ... and I need splited from start date until end date that is always = todays date.

thks
Paulo


Hi @pmargarido ,

 

I read it carefully, but I don't understand what you want to split? Under what conditions?


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

Hello  V-lianl-msft
thks for your reply 
I want to split the commission amount per payment type , month, trimester, etc , from strat date to end date .
hope this calrify 

Payment typeDt.StartDt.EndCommision
Month22/04/201906/10/2021€ 317,06
Trimester02/10/201906/10/2021€ 339,52
Semester31/07/201806/10/2021€ 293,27
Month29/05/201806/10/2021€ 388,12
Month20/06/201806/10/2021€ 821,50

 

KR
Paulo

Helpful resources

Announcements
April AMA free

Microsoft Fabric AMA Livestream

Join us Tuesday, April 09, 9:00 – 10:00 AM PST for a live, expert-led Q&A session on all things Microsoft Fabric!

March Fabric Community Update

Fabric Community Update - March 2024

Find out what's new and trending in the Fabric Community.