Slicer that summerize every month with the next month

[bkoenen]

Hello,

I have got a table with stock values, these are purchuse orders with a date and a value. Now I have a slicer in my dashboard where I can select the month's. But the value it shows is from the first of the chosen month till the last date of that month. But I want that it summerize from the first month till the last month.

Stock data

January 100,00

February 200,00

March 150,00

Example how it should be:

When I select in the slicer the months January and February the result should be like this:

January 100,00

February 300,00     result comes from (January 100,00 + February 200,00)

When I select in the slicer the months January and February and March the result should be like this:

January 100,00

February 300,00    result comes from (January 100,00 + February 200,00)

March 450,00        result comes from(January 100,00 + February 200,00 + March 150,00)

Does anyone have a solution for this?

With kind regards,

Björn

[MFelix]

Hi @bkoenen ,

You can use the time intelligence functions:

Total = CALCULATE ( SUM(Table[StockValue]), DATESYTD(Table[Date]))

[bkoenen]

Hello Miguel,

I added a column with your Dax formula, but I get exact the same result as before.

Formula:

Voorraadwaarde Calc = CALCULATE ( SUM('In en verkoop'[Voorraad waarde]), DATESYTD('In en verkoop'[Leverdatum].[Date]))

I would like to have that November gives the value 5.062.231,06 (Sum=October + November)

With kind regards,

Björn

[MFelix · Accepted solution]

Hi @bkoenen ,

This is not a calculated column this is a Measure.

Measures are calculated based on context so when you get it on your visualizations the date context is picked up for the calculation.

[bkoenen]

Hi Miguel,

I made a measure with the DATESYTD and it works fine, thank you.

Kind regards,

Björn