Displaying difference based on date

[abukapsoun]

Hi, 

Need your help please 

How can I create a measure showing the difference of (Average value of this day) - (Average value of last day)?

Regards,

Mohamed 

[MahyarTF · Accepted solution]

Hi

Use the below Measure :

ChengeVal =

Var __CurrDateValue = CALCULATE(AVERAGE(TableName[Value]), ALLEXCEPT(TableName,TableName[Date]))

Var __LastDayValue  = CALCULATE(AVERAGE(TableName[Value]), PREVIOUSDAY(TableName[Date]))

return __CurrDateValue - __LastDayValue

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