Calculate value based on months between two date values with month selection

[BobKoenen]

HI you all,

I am trying to create an overview to calculate the monetary value of the outstanding leave of persons for the year 2020. 

In the top of my report I have a month slicers in which you can select the months of this year. 

Person	Amount of leave	Hourrate	Begin contract	eind contract
a	20	20	1-1-2010
b	20	15	1-2-2020
c	40	25	1-6-2019	31-3-2020

Sow if I would want to know the value of outstanding leave for Januari the calculation should look like this:

Person a: 12 months in contract for 2020= (20*20)/12 = 33.333

Person B: Has no contract =0

Person C: 3months of contact for 2020 = (40*25)/3=333.33

For UNTIL April 

Person a: 12 months in contract for 2020 and 4 past= ((20*20)/12) *4 = 133.333

Person b: 11 months in contract for 2020 and 3 past= ((20*15)/11)*3=  81.81

Persen C=  Has no contract =0

I hope i have explained it clearly and you can help me. 

[Greg_Deckler · Accepted solution]

Not really. But perhaps:

https://community.powerbi.com/t5/Quick-Measures-Gallery/Open-Tickets/td-p/409364

Or maybe:

See if my Time Intelligence the Hard Way provides a different way of accomplishing what you are going for.

https://community.powerbi.com/t5/Quick-Measures-Gallery/Time-Intelligence-quot-The-Hard-Way-quot-TIT...