MonthEnd and YearEnd

[gco]

I am pulling data for the whole year daily (with postdate as daily).  And i am trying to figure out how to create a measure for each monthend and display it on a table/matrix and yearend totals in PowerBI.  Any help would be appreciated.

I have columns  LoanType, PostDate, LoanBalance.

I am looking for something like:

Post Date	1/31/2019	2/28/2019	3/31/2019
LoanType
1	$500	$600	$700
2	$600	$200	$200
3	$300	$100	$700

Thank you

Glen

[gco · Accepted solution]

I think i got a working solution.  On my table, i created a new column called MonthEnd.

MonthEnd = EOMONTH('Table'[POSTDATE],0)

And used that as a column in my matrix.