How to get the Previous Month Text Value

[yyyyyyvonne]

Hi, I'm trying to get the text value from the previous month in the following table, which is about trying to see the employee transfer from which department. Does anyone know how to get it?

Thank you in advance!!

[Greg_Deckler · Accepted solution]

@yyyyyyvonne Maybe:

Previous Month Column =
  VAR __Date = [Date]
  VAR __Name = [Name]
  VAR __PreviousDate = MAXX( FILTER('Table', [Name] = __Name && [Date] < __Date ), [Date] )
  VAR __PreviousDept = MAXX( FILTER('Table', [Name] = __Name && [Date] = __Date ), [Department] )
RETURN
  __PreviousDept

This is actually the last example in this video: