Forum Discussion
Quick Measures - DOD (Day over Day) - DAX Help
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!
Anonymous,
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-Query/m-p/176997
https://stackoverflow.com/questions/40903902/dax-query-on-day-over-day
Regards,
Lydia
2 Replies
Anonymous,
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-Query/m-p/176997
https://stackoverflow.com/questions/40903902/dax-query-on-day-over-day
Regards,
Lydia- arvindyadav
Post Partisan
Hi Anonymous ,
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
