Forum Discussion

gco's avatar
gco
Resolver II
6 years ago
Solved

MonthEnd and YearEnd

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 Date1/31/20192/28/20193/31/2019
LoanType   
1$500$600$700
2$600$200$200
3$300$100$700

 

Thank you

Glen

Need Help
  • gco's avatar
    gco
    6 years ago

    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.

1 Reply

  • gco's avatar
    gco
    Resolver II
    6 years ago

    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.