Measure to show value from last year if blank

luismolle — Wed, 30 Aug 2023 12:57:19 GMT

Hello!

I have a DAX measure doing some calcs in a table. What im trying to do is, for the values that I still dont have the calcs (blanks), it should show the value from last year.

Example with Image: for July 2023, it should show the value from July 2022 (1,416,733,167.125), August 23 should show the value from August 22 and so on.

thanks.

Luis.

Re: Measure to show value from last year if blank

parry2k — Wed, 30 Aug 2023 16:14:59 GMT

luismolle assuming you are using a date dimension.

As a best practice, add a date dimension in your model and use it for time intelligence calculations. Once the date dimension is added, mark it as a date table on table tools. Check the related videos on my YT channel

Add Date Dimension
Importance of Date Dimension
Time Intelligence Playlist

You can try following measure:

New Measure = COALESCE( [Existing Measure], CALCULATE ( [Existing Measure], SAMEPERIODLASTYEAR ( 'Date Table'[Date] ) ) )

topic Re: Measure to show value from last year if blank in DAX Commands and Tips

Measure to show value from last year if blank

Re: Measure to show value from last year if blank