Forum Discussion
Distributing multiple values over different time periods
It seems super strange to me to set this up as a calculated column. Would you have the same contract number in multiple rows, along with every working date between start and end of contract, and the expected amount? That seems like a stupidly large amount of data replication.
When you say "if X is valid for all days of Z", how can you tell whether this is true for a given day and contract?
Would it make more sense with your data to take the contract start date instead of TODAY() as the first date, and then do the same math with that as a starting point?
If the solution is a measure or a calculated column does not matter to me.
Does it help to take the contract start date? At the end I will filter on future days anyway.
Do you see the point where I am struggling? I need to make sure that the daily values are considered only for those days, where the date of the day is before (or on) the contract expiry date.
e.g. having a contract with total value 12k and expiry date 13.09.2019 -> daily value (future working days only) = 1k and now I want Power BI to consider this 1k for every day until expiry date; at the end I want to see, that the distributed contract value for August is 2k and for September it is 10k