Forum Discussion

MahyarTF's avatar
MahyarTF
Icon for Memorable Member rankMemorable Member
3 years ago

Hi,

You could use below measure :

Last30DaysValue = CALCULATE(sum(Sheet120[Fee]), FILTER(sheet120, Sheet120[Date] > TODAY()-30))

 

Appreciate your Kudos and please mark it as a solution if it helps you

  • aishak12's avatar
    aishak12
    Icon for Helper IV rankHelper IV
    3 years ago

    I tried this and no data is appearing in my visual. This is the Date field. I want the SUM of labor billed in the past 30 days 

     

     



    • MahyarTF's avatar
      MahyarTF
      Icon for Memorable Member rankMemorable Member
      3 years ago

      Did you try to create the measure on Date field ?

      And would you please share the result of the new measure you created ?