Forum Discussion
Solved
Calculate previous week values
Hello , I have the following table in Power Bi : Movement type Calendar week Actual PreviousWeek Net Growth 202452 50 Net Disconnections 202452 750 Net Connections 202452 ...
Hi romina80,
You can use below DAX logic to create new Calculated column
PreviousWeek = VAR CurrentMovement = 'Movements'[Movement type] VAR CurrentWeek = 'Movements'[Calendar week] VAR PreviousWeekNumber = CALCULATE(MAX('Movements'[Calendar week]), FILTER('Movements', 'Movements'[Calendar week] < CurrentWeek)) RETURN CALCULATE(MAX('Movements'[Actual]), FILTER('Movements', 'Movements'[Movement type] = CurrentMovement && 'Movements'[Calendar week] = PreviousWeekNumber ))Thanks,
If you found this solution helpful, please consider giving it a Like👍 and marking it as Accepted Solution✔. This helps improve visibility for others who may be encountering/facing same questions/issues.
Hi romina80
Try using filtered TopN:
Prev Week =
VAR _type = 'Table'[Movement type]
VAR _week = 'Table'[Calendar week]
VAR _prevWeekRow =
TOPN (
1,
FILTER (
'Table',
'Table'[Calendar week] < _week && 'Table'[Movement type] = _type
),
[Calendar week], DESC
)
RETURN
MAXX ( _prevWeekRow, [Actual] )