Profile Topics Started Replies Created Favorites Forum Replies Created Viewing 2 posts - 1 through 2 (of 2 total) Author Posts July 18, 2017 at 8:42 pm in reply to: Cash Flow #8165 peterhof3Participant Started: 0Replies: 2Total: 2 Rogerio; Have a look at these two blogs: https://powerpivotpro.com/2011/12/cash-flow-statement-in-powerpivot/ also here https://powerpivotpro.com/2011/12/the-greatest-formula-in-the-world-part-one/ this one resolved my issue in getting the previous month’s data (you have to fiddle it a bit). HTH July 18, 2017 at 5:06 pm in reply to: Cash Flow #8164 peterhof3Participant Started: 0Replies: 2Total: 2 Hi! I am actually struggling with the same thing. Did you manage to find a solution to this. I have tried to use PM Sales:= ([Sales], Dateadd(‘Calendar'[FullDate], -1 , Month)) , but this only seems to give me the Sum of all sales for the year. Author Posts Viewing 2 posts - 1 through 2 (of 2 total)