Forum Discussion
Sum Cost from Multiple Lines into a Single Row
Hi everyone, and thanks in advance for any help on this one....it's very much appreciated!! So to try and summarize, I have a Dynamics 365 Table in Power BI that links to our Projects module and ...
lbendlin
Super User
Super User- This sounds like a rather fragile process. Can you guarantee that there will ever only be a single revenue line in between cost lines? Can you guarantee that the cost timestamp absolutely reliably is before the revenue timestamp? What if there is no cost entry betwen two revenue entries? What if there is no revenue for a group of cost records?
I think guarantee is a strong word, and I can't guarantee these situations would not occur. That being said, I think that presumably and reliably,
- There would only be a single revenue line in between cost lines
- cost timestamps would be before revenue timestamps
- a revenue recogniation process would not be run or in the case of multipl rev rec 'Estimate' processes re-run unless there was additional cost
- I would expect there to be solid 6-9 month timespans where cost entries are happening but for which the first revenue recognition process would not yet occur