Forum Discussion

paglioz3's avatar
paglioz3
New Member
5 years ago
Solved

problem with total progressive

Hi all, I need to calculate a progressive value in base of the period filtered by user, from older to laster, but the result sum start from the last date. I use the script:   progressive_value= V...
Need Help
  • v-kelly-msft's avatar
    v-kelly-msft
    5 years ago

    Hi  paglioz3 ,

     

    Try below expression:

    progressive_value =
VAR MinDate =
MINX ( ALLSELECTED ( 'CALENDAR'),'CALENDAR'[Date] ) -- Saves the last visible date
RETURN
CALCULATE ( [value], 'CALENDAR'[Date] >= MinDate )

     

     

     

    Best Regards,
    Kelly

    Did I answer your question? Mark my post as a solution!

vanessafvg's avatar
vanessafvg
Community Champion
5 years ago
you mean like this?

progressive_value =
VAR MinDate =
MIN ( ALLSELECTED ( 'CALENDAR'[Date] ) ) -- Saves the last visible date
RETURN
CALCULATE ( [value], 'CALENDAR'[Date] >= MinDate )
  • paglioz3's avatar
    paglioz3
    New Member
    5 years ago

    Thank's but no, with ALLSELECTED funtion returned an error (

    the MIN function accepts only a column reference as an argument
    )

    for completeness, the measure [value] = calculate(sum([import]))

    • v-kelly-msft's avatar
      v-kelly-msft
      Community Support
      5 years ago

      Hi  paglioz3 ,

       

      Try below expression:

      progressive_value =
VAR MinDate =
MINX ( ALLSELECTED ( 'CALENDAR'),'CALENDAR'[Date] ) -- Saves the last visible date
RETURN
CALCULATE ( [value], 'CALENDAR'[Date] >= MinDate )

       

       

       

      Best Regards,
      Kelly

      Did I answer your question? Mark my post as a solution!

      • paglioz3's avatar
        paglioz3
        New Member
        5 years ago

        Thanks!

        Below the complete code:

         
        progressive_value =
        VAR MinDate = MINX ( ALLSELECTED ( 'CALENDAR'),'CALENDAR'[Date] ) -- Saves the last visible date
        var MaxDate = MAX ('IND'[Date])
        var Value= CALCULATE (IND[Amount])
        RETURN
        CALCULATE ( Value, 'CALENDAR'[Date] >= MinDate, 'CALENDAR'[Date] <= MaxDate )