Hello -
I have a table that contains a receivables account. Obviously with that the receivables is a rolling account. I have some situations that I need to us previous day and previous month ending receivables. I need to make a pivot that shows the beginning balance (end of previous day) of rec + sales - payments = ending receivables. I also have some calcs that use the ending receivables balance of the previous month. I was thinking I would make a new column for each with a DAX formula but it doesn't seem to be working. Here is what I was attempting for the end of previous month Receivables balance.
=CALCULATE([Sum of Balance],DATESBETWEEN(CD128TABLE[RPT_DATE],EOMONTH([Today],-1),EOMONTH([Today],-1))) but it doesn't show anything. The reason it is Sum of balance is because there are different divisions. I've also tried
=CALCULATE([Sum of Balance],FILTER(Dim_Date[Date],EOMONTH([Today],-1))). Any ideas?
I have a table that contains a receivables account. Obviously with that the receivables is a rolling account. I have some situations that I need to us previous day and previous month ending receivables. I need to make a pivot that shows the beginning balance (end of previous day) of rec + sales - payments = ending receivables. I also have some calcs that use the ending receivables balance of the previous month. I was thinking I would make a new column for each with a DAX formula but it doesn't seem to be working. Here is what I was attempting for the end of previous month Receivables balance.
=CALCULATE([Sum of Balance],DATESBETWEEN(CD128TABLE[RPT_DATE],EOMONTH([Today],-1),EOMONTH([Today],-1))) but it doesn't show anything. The reason it is Sum of balance is because there are different divisions. I've also tried
=CALCULATE([Sum of Balance],FILTER(Dim_Date[Date],EOMONTH([Today],-1))). Any ideas?