Forum Discussion
Solved
How to create same period last year without date column. only with month and year
Account month year Value A Jan-23 5389 B Jan-23 6450 C Jan-23 6159 A Jan-24 5797 B Jan-24 6381 C Jan-24 5993 A Jan-25 5274 B Jan-25 6049 C Jan-25 65...
Hi,
PBI file attached.
Hope this helps.
GeraldGEmerick
Memorable Member
Memorable MemberArpitaRampur Here is a measure that does that:
Last Year =
VAR _MY = MAX( 'Table'[month year] )
VAR _Month = LEFT( _MY, 4 )
VAR _Year = RIGHT( _MY, 2 ) + 0
VAR _LY = _Year - 1
VAR _LYMY = _Month & _LY
VAR _Return = CALCULATE( SUM( 'Table'[Value] ), 'Table'[month year] = _LYMY )
RETURN _Return