Forum Discussion

amirghaderi's avatar
amirghaderi
Icon for Helper IV rankHelper IV
5 years ago
Solved

Rolling Sum - Last period

I have a rolling sum measure as below which measures 3 weeks rolling of column "periodic:Earned". I want another measure which only calculate the the last period rolling sum and everything else to be...
Need Help
  • Jihwan_Kim's avatar
    Jihwan_Kim
    5 years ago

    Hi, amirghaderi 

    I am not sure hour your whole data model looks like, but the simplest way (in my opinion) is, adding an IF condition something like below.

     

    Qty total 21days rolling =
    if ( not isblank( [Qty total]), your measure......)

     

    Hi, My name is Jihwan Kim.

     

    If this post helps, then please consider accept it as the solution to help other members find it faster, and give a big thumbs up.

     

    Linkedin: linkedin.com/in/jihwankim1975/

    Twitter: twitter.com/Jihwan_JHKIM

     

Jihwan_Kim's avatar
Jihwan_Kim
Icon for Super User rankSuper User
5 years ago

Hi, amirghaderi 

I think, in your table visualization, the Dates[Date] is not used. Instead, [Date to 2] is used. 

 

Hi, My name is Jihwan Kim.

 

If this post helps, then please consider accept it as the solution to help other members find it faster, and give a big thumbs up.

 

Linkedin: linkedin.com/in/jihwankim1975/

Twitter: twitter.com/Jihwan_JHKIM

amirghaderi's avatar
amirghaderi
Icon for Helper IV rankHelper IV
5 years ago

Thanks for your response, it looks much better now. How can I stop the calculating moving sum for future periods, highighted below?

 

  • Jihwan_Kim's avatar
    Jihwan_Kim
    Icon for Super User rankSuper User
    5 years ago

    Hi, amirghaderi 

    I am not sure hour your whole data model looks like, but the simplest way (in my opinion) is, adding an IF condition something like below.

     

    Qty total 21days rolling =
    if ( not isblank( [Qty total]), your measure......)

     

    Hi, My name is Jihwan Kim.

     

    If this post helps, then please consider accept it as the solution to help other members find it faster, and give a big thumbs up.

     

    Linkedin: linkedin.com/in/jihwankim1975/

    Twitter: twitter.com/Jihwan_JHKIM