Help on creating measure

[Heena_9980400]

Hi Experts,

I need to create a measure, where I should get a difference between the a and c columns for yesterday, Im just confused about how can we do a difference in calculating the function.

Need guidance on this.

Thanks & Regards,

Heena Kousar

[DOLEARY85]

Hi,

try a calculated column:

Column = CALCULATE(sum('Table)'[A]),DATEADD('Table)'[Date],-1,DAY))/CALCULATE(sum('Table'[C]),DATEADD('Table'[Date],-1,DAY))

If I answered your question, please mark my post as solution, Appreciate your Kudos 👍