How Calculate Daily Productivity

[Reynolds428]

Hello. I'm trying to find a solution to calculate daily productivity by taking the difference between the sum of today's (latest data input) value and the sum of yesterday's (or last data input value). Can someone assist?

For example, if the sum of a column for today (latest data input date) = 25 and the sum of a column for yesterday (previous data input date) = 10. Then, my productivity for today = 15.

[v-lili6-msft]

hi   @Reynolds428 

Just create a measure by DATEADD Function like this:

productivity = SUM('Table'[Value])- CALCULATE(SUM('Table'[Value]),DATEADD('Table'[Date],-1,DAY))

 https://docs.microsoft.com/en-us/dax/dateadd-function-dax

Regards,

Lin