Forum Discussion

Kolumam's avatar
Kolumam
Post Prodigy
6 years ago
Solved

Calculating prorated value based on a condition

I have the below table. I need to calculate the annual contract based on the start date and end date of the contract.   As you can see from the above table, the first contract starts at 1 Ju...
General Comment
Need Help
Show and Tell
Tips and Tricks
Tutorial Requests
  • tex628's avatar
    tex628
    6 years ago

    Hello Kolumam,

    Take a look at the pbix attached to this reply, i hope it can provide some insight! 

    Br, 
    J

tex628's avatar
tex628
Community Champion
6 years ago

Hello Kolumam,

Take a look at the pbix attached to this reply, i hope it can provide some insight! 

Br, 
J