Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!

How Calculate Daily Productivity

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.

Status: New
Comments
v-lili6-msft
Community Support

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