Repeat value after sales date

[Jyaul1122]

Dear Friend,

I have two table , calendar and sales table. and i have one Measure1 that give data upto Mar-24. on i want to display data like in Measure 2 i.e. the final data 25 (newest data based on Month) should be available upto end of date.

Like:

Calendar(Month)	Measure 1	Measure 2
Dec-23	5
Jan-24	10
Feb-24	15
Mar-24	25	25
Apr-24		25
May-24		25
Jun-24		25

 how can i achieve using DAX.

[v-tangjie-msft · Accepted solution]

Hi @Jyaul1122 ,

I want to acknowledge valuable input provided by @ThxAlot  . Their initial ideas help guide my approach. However, I noticed that more details are needed to fully understand this issue.

You can create a measure as shown below.

Measure 2 = 
 var _a=CALCULATE(MAX('Date'[YYYYMM]),FILTER(ALL('Date'),[Measure 1]<>BLANK()))
 RETURN 
 IF(ISBLANK([Measure 1]),CALCULATE(LASTNONBLANKVALUE('Date'[YYYYMM],[Measure 1]),'Date'[Date]<=MAX('Date'[Date])),IF(MAX('Date'[YYYYMM])=_a,[Measure 1]))

Then the result is as follows.

Best Regards,

Neeko Tang

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

[ThxAlot]

[Jyaul1122]

@ThxAlot ,Thanks for reply but i would like to get from March-2024.