Forum Discussion
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 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.
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.
3 Replies
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.
