Forum Discussion
Calculating difference within same measure and changing with slicer
The problem with your measure is that it has hard coded the date prior as the day -1 . In the filtered table you don´t have concurrent days, so that creates a "prior day" that is not in there.
This article deals exactly with this issue, if it´s not clear let me know and I´ll help you. ([email protected])
Hope this helps!!
https://www.sqlbi.com/articles/optimizing-lastnonblank-and-lastnonblankvalue-calculations/?nu=92211
@lastnonblank
The problem with your measure is that it has hard coded the date prior as the day -1 . In the filtered table you don´t have concurrent days, so that creates a "prior day" that is not in there.
This article deals exactly with this issue, if it´s not clear let me know and I´ll help you. ([email protected])
Hope this helps!!
https://www.sqlbi.com/articles/optimizing-lastnonblank-and-lastnonblankvalue-calculations/?nu=92211
@lastnonblank