Forum Discussion

PBIdeas's avatar
PBIdeas
Icon for Advocate I rankAdvocate I
5 years ago

Calculation based on Start and End dates

Hi,   I'm trying to build a calculation for a CTC model (Cost-to-Complete) with three conditions:   Only calculate from a given (dynamic) start date based on when the model was updated ("Update"...
Need Help
amitchandak's avatar
amitchandak
Icon for Super User rankSuper User
5 years ago

PBIdeas , At start you are using Sum(Table[Start Date]) , Try , Min for start date and Max for end date . Also make sure you calendar has all the dates till last end date 

PBIdeas's avatar
PBIdeas
Icon for Advocate I rankAdvocate I
5 years ago

Many thanks Amit!

 

This has fixed the date issue, however when I now multiply the CTC days by the daily Revenue rate the values remain  the same even when people are no longer included in the CTC days - see below:

 

 

What is wrong here? It looks like the results are not being interpreted as aggregations.