Fill blank values with last not blank value

Asmonk , Try a measure like below. However large data may slow down the measure too

 

measure =

If(isblank(max(Table[Price])), calculate(lastnonblankvalues(Table[Date], max(Table[Price])), filter(all(Table), Table[Product] = Max(Table[Product]) && Table[Date] <= max(Table[Date]))),max(Table[Price]) )

Hi Asmonk ,

amitchandak Nice answer!
Have you solved your problem? If not, when you use DAX to solve it, both the measure and calculated columns take up more computer memory. If you can use Power Query, you can try this way and it will reduced computer memory footprint:
First, please Duplicate the original Table:

And in the Table(2), filter Product = A:

Select Column Price and click Fill down, and the output is as below:

In Table(3), filter Product = B and do the same Fill down on Column Price, and the output is as below:

Select original Table and click Merge Queries as New:

The output is as below:

Expand the column:

And Merge Queries as New again:

Expand again:

The output is as below:

Choose this two columns and click merge columns:

The final output is as below:

The above method is realized by operation, here we provide a simpler but need to be realized by M function. Just put the following code into Advanced Editor:

let
    Source = Table.FromRows(Json.Document(Binary.Decompress(Binary.FromText("i45WMjTSNzbUNzIwMlbSUXIEYkOlWB00YScgNoII64MFTaBq0cWcEGJGyOqM0QVBCk2hgsZYTDRGVmimFBsLAA==", BinaryEncoding.Base64), Compression.Deflate)), let _t = ((type nullable text) meta [Serialized.Text = true]) in type table [Date = _t, Product = _t, Price = _t]),
    #"Changed Type" = Table.TransformColumnTypes(Source,{{"Date", type date}, {"Product", type text}, {"Price", Int64.Type}}),
    #"Grouped Rows" = Table.Group(#"Changed Type", {"Product"}, {{"Count", each Table.FillDown(_,{"Price"})}}),
    #"Expanded Count" = Table.ExpandTableColumn(#"Grouped Rows", "Count", {"Date", "Price"}, {"Count.Date", "Count.Price"})
in
    #"Expanded Count"

The final output is the same:

Best Regards,
Dino Tao
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

Hi,

PBI file attached.

Hope this helps.