Quick Measures - DOD (Day over Day) - DAX Help

[irnm8dn]

I have a simple table that shows me a record count by day.  I am looking to chart the difference between days, to represent growth or loss of recors between days.

Quick measures does not include a DOD calc?

Hoping someone can help me with the DAX formula.

Thanks!

[v-yuezhe-msft · Accepted solution]

@irnm8dn,

You can review the following examples to calculate DOD. if you still have issues with the DAX, please share dummy data of your  table to us.

https://community.powerbi.com/t5/Desktop/Day-to-day-difference-in-cumulative-values-DAX-or-Power-Que...
https://stackoverflow.com/questions/40903902/dax-query-on-day-over-day

Regards,
Lydia

[arvindyadav]

Hi @v-yuezhe-msft ,

It's not working when I select any name on slicer because of the negative value coming on the previous day. Can you suggest me what to do to avoid that negative value?

Thanks,

Arvind