Forum Discussion

8 Replies

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

      I would like the SUM of Labor Billed for the past 30 days 

      • Ashish_Mathur's avatar
        Ashish_Mathur
        Icon for Super User rankSuper User
        3 years ago

        Hi,

        In the Query Editor, seperate the Time from the End Date column.  Create a Calendar Table and a relationship (Many to One and SIngle) from the End Date column to the Calendar Table.  Wrie these measure

        LB = sum(Data[Labor billed])

        LB in last 30 days = calculate([LB],datesbetween(calendar[Date],today()-29,today()))

        Drag the LB in last 30 days measure to a card visual.

        Hope this helps.

         

  • 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 ?