Forum Discussion
Solved
Quantifying Total Invoiced Per Month
Hello, I'm trying to create a monthly budget tracking system that tells me how much money I've invoiced every month. I have a data set that updates twice a month on what purchase orders have been...
pls see the attachment below
pls check if this is what you want
create columns
date = date(year('Table'[Date Modified]),month('Table'[Date Modified]),1)
Column =
var _last=maxx(FILTER('Table','Table'[Purchase Order]=EARLIER('Table'[Purchase Order])&&'Table'[date]=EDATE(EARLIER('Table'[date]),-1)),'Table'[Invoiced Amount ])
return if(ISBLANK(_last),'Table'[Invoiced Amount ],'Table'[Invoiced Amount ]-_last)
ifmax = if('Table'[Column]=CALCULATE(max('Table'[Column]),ALLEXCEPT('Table','Table'[Purchase Order],'Table'[date])),"Max")
pls see the attachment below