Hi,
I am having issue with the last blank value as I am trying to show a tab with the Date - Value - last non empty value . I use the demo sample from dax.io ( the link include my code )
https://dax.do/dD83JH5nka6NhB/
The query I use is
define
measure Sales[Sales Amount Last]=
LASTNONBLANKVALUE ( 'Date'[Date], [Sales Amount] )
EVALUATE
CALCULATETABLE (
ADDCOLUMNS ( VALUES ( 'Date'[Date] ), "Sales Amount", [Sales Amount] ,
"Last non blank",Sales[Sales Amount Last]
),
'Date'[Date] >= DATE ( 2007, 2, 7 ) &&
'Date'[Date] <= DATE ( 2007, 2, 16 )
)
But I have the same blank on the column Sales Amount and the column Last non blank. I was expecting the Last non blank value to show the value from the previous day when blank.
But the result is similar in both column :
So I was expecting to see 15,502.99 on the column "Last non blank" for the date 2007-02-07. Any idea what I am missing ?

or upvote
button whenever the information provided helps you. Original posters help the community find answers faster by identifying the correct answer. Here is