Forum Discussion
Solved
Calculating difference within same measure and changing with slicer
Hi Experts, This is my first post regarding Power bi and this is my first time creating dashboard in Power bi. I have created a measure which is speed and I'm using slicer which is like production r...
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
