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
Show and Tell
Tips and Tricks

3 Replies

  • DOLEARY85's avatar
    DOLEARY85
    Resident Rockstar
    3 years ago

    Hi,

     

    create a calculated column and use:

     

    Column = CALCULATE(sum('Table (8)'[A]),DATEADD('Table (8)'[Date],-1,DAY))/CALCULATE(sum('Table (8)'[B]),DATEADD('Table (8)'[Date],-1,DAY))
     
    If I answered your question, please mark my post as solution, Appreciate your Kudos 👍