Previous Month and Current Month side by side

[alexoriginal]

Hello

I am trying to get  Prev-month-year  || Current-month-year  columns side by side  as  in the image shown

However Its seesm like the only way I can do this is manually.

Does anyone know a way  this can be done by just using a matrix /table so that the month show up automatically based on date ? ( See image) 

[Anonymous · Accepted solution]

Step 1:  Have a date column that is either formatted as MMM-YY  (I.e.  March-2018). Formatting can be achieved in the Modeling Tab of the ribbon -> Format

Step 2:  Have a matrix that will show the data you need.

Step 3: Place the date column into the "Column Area of the matrix"

Step 4: In the 'Visual Filter', filter by your date column using Relative Dates.  Select the appropriate settings to get the 2 months you want.

Does that handle what you were hoping for?