Display only two rows month wise in Table Visual with DAX

[archerjayden]

Hi,

I am trying to achieve the table with comments as seen in the image below ... I wanted to display only two rows for each month but I am getting them as below 

DAX Calc 

June = if([period] = MONTH(today())-1, program[comments],blank())
July = if([period] = MONTH(today()), program[comments],blank())
August = if([period] = MONTH(today())+1, program[comments],blank())

Current State

Desired State

[amitchandak]

The information you have provided is not making the problem clear to me. Can you please explain with an example.

Appreciate your Kudos.