How can I only show the balances per the first of each month

[DLU]

Dear Community, 

I'm currently building a cashflow statement and I'm having some difficulties with showing the balances per the first of each month. The balances at the end of each month gives no problems because I can use the YTD formula there. I've tried to do something with Startofmonth but I can't seem to get the right data. Just to get an idea of the fields I need to include. These are the formula's I used to get to the balances at the end of each month: 

Cash at end of the month = CALCULATE(SUMX(VALUES('Mapping Cashflow'[Report Sign]);SUMX(RELATEDTABLE('DWH');'DWH'[ACCOUNTINGCURRENCYAMOUNT]*'Mapping Cashflow'[Report Sign])))

And to get the YTD balances I used: 

YTD Cash at end of month = TOTALYTD('Metingen Cashflow'[Cash at end of the month];'Date'[Date])

As I already mentioned, I tried to at a filter to the first formula, so like this: 

Cash at beginning of month = Calculate(SUMX(VALUES('Mapping Cashflow'[Calculating Sign]);SUMX(RELATEDTABLE('DWH');'DWH'[ACCOUNTINGCURRENCYAMOUNT]*'Mapping Cashflow'[Calculating Sign]));STARTOFMONTH('Date'[Month]))

But that didn't work, and also, I think it would only work with the first month, because the cumulated balances are not stored each day, so it will need to add up the totals coming up to the first day of the month. 

Many thanks in advance!

Gr DLU

[DLU · Accepted solution]

I'm really sorry, while I was posting this one other thought came to mind and that worked :). Offcourse, the balance at the beginning of each month is the ending balance of the previous month, so I just referred to the formula for the end of each month and added previous month, like this: 

YTD Cash at beginning of month = CALCULATE([YTD Cash at end of month];PREVIOUSMONTH('Date'[Date]))

And it works 🙂

[amitchandak]

@DLU , Try a measure like

Calculate(SUMX(VALUES('Mapping Cashflow'[Calculating Sign]);SUMX(RELATEDTABLE('DWH');'DWH'[ACCOUNTINGCURRENCYAMOUNT]*'Mapping Cashflow'[Calculating Sign]));filter( 'Date', 'Date'[Date] = eomonth('Date'[Date],-1) +1))