Forum Discussion

Jyaul1122's avatar
Jyaul1122
Helper III
2 years ago
Solved

Repeat value after sales date

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...
Need Help
  • Anonymous's avatar
    Anonymous
    2 years ago

    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. 

     

     

Anonymous's avatar
Anonymous
Not applicable
2 years ago

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.