Sum column on last day of month

[Anonymous]

Hi,

I want to sum up the numbers in the column ActiveLast30ChargeAndDrive on the last day of every month. The highlighted rows are all on the last day of january 2018. How can I create a measure to calculate the sum  of these rows for every last day of the months?

BR Lars

[v-yangliu-msft]

Hi  @ Arnis_88 ,

Here are the steps you can follow：

1. Create a measure.

Measure =
CALCULATE(
    SUM('Table'[ActiveLast30ChargeAndDrive]),
    FILTER('Table',
    'Table'[DateKey]=ENDOFMONTH('Table'[DateKey])))

2. Result.

You can downloaded PBIX file from here.

Best Regards,

Liu Yang

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

[amitchandak · Accepted solution]

@Anonymous , Try closingbalancemonth, with date table

https://docs.microsoft.com/en-us/dax/closingbalancemonth-function-dax

closingbalancemonth(sum(Table[value]), date[date])

You refer to this video if needed -https://www.youtube.com/watch?v=yPQ9UV37LOU