cancel
Showing results for
Did you mean:

Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.

Frequent Visitor

## 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!

1 ACCEPTED SOLUTION
Community Support

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] )
)
)
``````

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.

Community Support

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] )
)
)
``````

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.

Announcements

#### Microsoft Fabric Learn Together

Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City

#### Power BI Monthly Update - April 2024

Check out the April 2024 Power BI update to learn about new features.

#### Fabric Community Update - April 2024

Find out what's new and trending in the Fabric Community.

Top Solution Authors
Top Kudoed Authors