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 c...
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

     

     

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