Forum Discussion

Zosy's avatar
Zosy
Icon for Helper II rankHelper II
1 year ago
Solved

Splitting contract amount over multiple years and months

Hi, I am struggling to create a measure that will calculate the sum of the contracts correctly. There are contracts longer than 1 year and currently I have a measure that adds up the cost of ite...
FBergamaschi's avatar
FBergamaschi
Icon for Super User rankSuper User
1 year ago

OK done

 

I choosed another contract after checking the one you indicated to double check that it works but please make checks and I can fix in case further

 

See my result

 

 

The pbix modified is here

 

https://drive.google.com/drive/folders/1Yh9ltc_AdI0S1_zUcq7yvQnePHznNCij?usp=sharing

 

If this helped, please consider giving kudos and mark as a solution

me in replies or I'll lose your thread

Want to check your DAX skills? Answer my biweekly DAX challenges on the kubisco Linkedin page

Consider voting this Power BI idea

Francesco Bergamaschi

MBA, M.Eng, M.Econ, Professor of BI

 

 

Zosy's avatar
Zosy
Icon for Helper II rankHelper II
1 year ago

Hi,

I have used the below and it works now. 

Contracts =
SUMMARIZE (
    'Invoices',
    'Invoices'[Invoice Number],
    "MaxStartDate", MAX ( 'Invoices'[Contract Start Date] ),
    "MaxExpiryDate", MAX ( 'Invoices'[Contract Expiry Date] )
)

 

Thank you so much for your help