Forum Discussion
MHTANK
Helper III
1 year agoPrevious_Value_as per Day_range
Date Year Month Day_Range Value 09-11-2024 2024 Nov 1-15 41.00 15-11-2024 2024 Nov 1-15 43.00 25-11-2024 2024 Nov 16-30 55.00 29-11-2024 2024 Nov 16-30 58.0...
- 1 year ago
Prev_Value =
VAR CurrentYear = SELECTEDVALUE('YourTable'[Year])
VAR CurrentMonth = SELECTEDVALUE('YourTable'[Month_Number])
VAR CurrentCustom = SELECTEDVALUE('YourTable'[Custom])RETURN
CALCULATE(
[Avg_Value],
TOPN(
1,
FILTER(
ALLSELECTED('YourTable'),
('YourTable'[Year] = CurrentYear && 'YourTable'[Month_Number] = CurrentMonth && 'YourTable'[Custom] < CurrentCustom) ||
('YourTable'[Year] = CurrentYear && 'YourTable'[Month_Number] < CurrentMonth) ||
('YourTable'[Year] < CurrentYear)
),
'YourTable'[Year], DESC,
'YourTable'[Month_Number], DESC,
'YourTable'[Custom], DESC
)
)
MHTANK
Helper III
1 year agoYa,
It's working very well
Thank you so much👍👍👍
Khushidesai0109
Skilled Sharer
1 year agoKeep Doing DAX!!
Kuddos are Appreciated