cancel
Showing results for
Did you mean:

Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and more. Get started

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

#### Europe’s largest Microsoft Fabric Community Conference

Join the community in Stockholm for expert Microsoft Fabric learning including a very exciting keynote from Arun Ulag, Corporate Vice President, Azure Data.

#### Power BI Monthly Update - June 2024

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

#### New forum boards available in Real-Time Intelligence.

Ask questions in Eventhouse and KQL, Eventstream, and Reflex.

Top Solution Authors
Top Kudoed Authors