Forum Discussion

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.

 

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

    can you show an example of this?

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

      Hi,

      Please follow the instructions i have mentioned in my previous message.