Forum Discussion

Heena_9980400's avatar
Heena_9980400
Helper IV
3 years ago

Help on creating measure

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

"Need Help"
Need Suggestions

1 Reply

  • DOLEARY85's avatar
    DOLEARY85
    Resident Rockstar
    3 years ago

    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 👍