Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
6 years ago
Solved

Rolling 5 days back

Hi Guys, 

 

I want to create a line chart with on the axis the date and in the value of the chart the total sum or count of 5 days back from every specific day on the axis. So if in the date axis comes the date 24-10-2019; I want that the linevalue on that date is a sum or count of the days (23-10, 22-10 ,21-10, 20-10, 19-10). 

 

I can't find  or make a measure to fix this, Please help! 

Need Help
Show and Tell
  • sanjeev803's avatar
    sanjeev803
    6 years ago

    Hi - Try below measure.

     

    Rolling 5 Days = CALCULATE(SUM(Data[Value]),DATESINPERIOD(Data[Date],LASTDATE(Data[Date]),-5,DAY))

     

    Refer date column in DATESINPERIOD(), and make sure its format is date.

     

    I hope this will help.

     

    Cheers!
    Sanj

     

     

3 Replies

  • sanjeev803's avatar
    sanjeev803
    Icon for Helper I rankHelper I
    6 years ago

    Hi - Try below measure.

     

    Rolling 5 Days = CALCULATE(SUM(Data[Value]),DATESINPERIOD(Data[Date],LASTDATE(Data[Date]),-5,DAY))

     

    Refer date column in DATESINPERIOD(), and make sure its format is date.

     

    I hope this will help.

     

    Cheers!
    Sanj

     

     

    • Anonymous's avatar
      Anonymous
      Not applicable
      6 years ago

      Nice it kinda works. 

      is it possible to set the three different colors(years) over each other.

      Now i have a date format on the axis, so the years are after eacht other. 

       

       

      • sanjeev803's avatar
        sanjeev803
        Icon for Helper I rankHelper I
        6 years ago

        Hi -  I guess this is not possible in power BI till now.

         

        Please mark previous reply as solution if that works for you.

         

        Kudos are even nice.

         

        Cheers!
        Sanj