Fill blank with values the month before

[LayneCobain]

Hey guys,

I need some help:

As you can see, I have an example with 2 products with different prices over the year and the previous year.

The matrix shows following measures:

This one shows the maximum price per month

Last Price = MAX ( Daten[Preis] )

This one shows the price of the product previous year in the same month:

PricePreviousYear = 
    CALCULATE(
        MIN(Daten[Preis]),
        SAMEPERIODLASTYEAR(Kalender[Datum])
    )

As you can see in the matrix there are some months the previous year without a price. I want to fill this up with the price the month before.

Example: Product A had a price of 60 in January previous year and I want to fill up February with this value.

How can I do this?

The fill up / down does not work, I need a measure.

Thank you guys!

[Anonymous · Accepted solution]

Hi @LayneCobain ,

I have created a simple sample , please refer to my pbix file to see if it helps you.

Create a measure.

Measure =
IF (
    [pricepreviousyear measure] <> BLANK (),
    [pricepreviousyear measure],
    CALCULATE (
        [pricepreviousyear measure],
        'Table'[date] = EDATE ( MAX ( 'Table'[date] ), -1 )
            && 'Table'[Monat product] = MAX ( 'Table'[Monat product] ),
        ALLEXCEPT ( 'Table', 'Table'[date] )
    )
)

How to Get Your Question Answered Quickly 

If it does not help, please provide more details with your desired output and pbix file without privacy information (or some sample data) .

Best Regards
Community Support Team _ Polly

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