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 Usercreate a measure to
- identify the revenue row
- get its timestamp
- find the last revenue row that occured before this one
- sum up the cost items that happened in the dates between those two timestamps
- return it for the revenue line. That will tag it to the right month.
Thanks so much lbendlin , very much appreciated.
Back to the community, any pointers on how I might go about seeting up this measure? I created quite a few reports in the past, but nothing with really more than quick measures. I'm not sure I'd know how to go about setting this one up.