Forum Discussion
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"...
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
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.
