cancel
Showing results for
Did you mean:
Helper I

## Slicer that summerize every month with the next month

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

1 ACCEPTED SOLUTION
Super User

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.

Regards

Miguel Félix

Proud to be a Super User!

Check out my blog: Power BI em Português

4 REPLIES 4
Super User

Hi @bkoenen ,

You can use the time intelligence functions:

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

Regards

Miguel Félix

Proud to be a Super User!

Check out my blog: Power BI em Português

Helper I

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

Super User

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.

Regards

Miguel Félix

Proud to be a Super User!

Check out my blog: Power BI em Português

Helper I

Hi Miguel,

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

Kind regards,

Björn

Announcements