Forum Discussion

Cakos's avatar
Cakos
Frequent Visitor
6 years ago

Cumulation other months

Hey everyone,   how can I cumulate the single values in my example over months in that way:   Month single value accumulated value January 1,09 1,09  February 1,45 2,54  March ...
Anonymous's avatar
Anonymous
Not applicable
6 years ago
It depends on many things. We don't even know if you're talking about a calculated column or a measure... To be able to accumulate values, you have to have a field that will tell how your entities are ordered. Here your entities are months but they could be anything...

Bset
D
  • Cakos's avatar
    Cakos
    Frequent Visitor
    6 years ago

    Hey Anonymous ,

     

    thx for your reply.

     

    I try to put my request into concrete terms:

     

    The column "month" in my example comes from a Date table (Calender with hierarchy) in my model.

    "Single value" is a calculated measure.

     

    Do you need more information?

     

    Many thanks!

    • Anonymous's avatar
      Anonymous
      Not applicable
      6 years ago
      // Base measure of which the accumulated value
// is a variation.
[Base Value] = SUM( FactTable[Value] )

[Accumulated Value] =
var __lastVisibleDate = max( Calendar[Date] )
var __result =
	calculate(
		[Base Measure],
		Calendar[Date] <= __lastVisibleDate,
		allselected( Calendar[Date] )
	)
return
	__result

       

      Best

      D

      • Cakos's avatar
        Cakos
        Frequent Visitor
        6 years ago

         Hey Anonymous ,

         

        thx for your reply.

         

        I tried it and this was the result:

         

         

        Any other ideas?

         

        Stay healthy!