cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
BobKoenen
Helper IV
Helper IV

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

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. 

PersonAmount of leaveHourrateBegin contracteind contract
a20201-1-2010 
b20151-2-2020 
c40251-6-201931-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. 

1 ACCEPTED SOLUTION
Greg_Deckler
Super User IV
Super User IV

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...


---------------------------------------

@ me in replies or I'll lose your thread!!!

I have a NEW book! 
DAX Cookbook from Packt
Over 120 DAX Recipes!




Did I answer your question? Mark my post as a solution!

Proud to be a Super User!




View solution in original post

1 REPLY 1
Greg_Deckler
Super User IV
Super User IV

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...


---------------------------------------

@ me in replies or I'll lose your thread!!!

I have a NEW book! 
DAX Cookbook from Packt
Over 120 DAX Recipes!




Did I answer your question? Mark my post as a solution!

Proud to be a Super User!




View solution in original post

Helpful resources

Announcements
PBI_User Group Leader_768x460.jpg

Manage your user group events

Check out the News & Announcements to learn more.

MBAS on Demand

2021 Release Wave 2 Plan

Power Platform release plan for the 2021 release wave 2 describes all new features releasing from October 2021 through March 2022.

Get Ready for Power BI Dev Camp

Microsoft named a Leader in The Forrester Wave

Microsoft received the highest score of any vendor in both the strategy and current offering categories.

R2 (Green) 768 x 460px.png

Microsoft Dynamics 365 & Power Platform User Professionals

DynamicsCon is a FREE, 4 half-day virtual learning experience for 11,000+ Microsoft Business Application users and professionals.