Formulas in a Matrix

Hi Maxigut1,

Yes, you can use the DAX below achieve you requirement.

Var.Vs Previous Day = (Matrix[Sum Departments]-LOOKUPVALUE(Matrix[Sum Departments],Matrix[Month Day],Matrix[Month Day]-1))/LOOKUPVALUE(Matrix[Sum Departments],Matrix[Month Day],Matrix[Month Day]-1)

Daily Total VS Daily Budget = Matrix[Sum Departments]-Matrix[Total Budget]

Estimated month end  = Matrix[Acumulated]+(Matrix[Acumulated]/Matrix[Month Day])*(Matrix[Days in month]-Matrix[Month Day])

Regards,

Charlie Liao