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 Po...
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.

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.