Forum Discussion

LayneCobain's avatar
LayneCobain
Frequent Visitor
3 years ago
Solved

Fill blank with values the month before

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!

Need Help
  • Anonymous's avatar
    Anonymous
    3 years ago

    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.

     

1 Reply

  • Anonymous's avatar
    Anonymous
    Not applicable
    3 years ago

    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.