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 )
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 ?