Column Header names should contain current month dynamically

[Hanuma_Srikiran]

Hi all,

I have a dataset as given below

ID	PREVIOUS MONTH SALES	CURRENT MONTH SALES
A	123464	4555556
B	466445	5555555

and I have to create a table chart as the following 

ID	September Sales	October sales
A	123464	4555556
B	466445	5555555

or month name should add to column header.

Any help will be appreciated.

Thanks in Advance.

[v-chuncz-msft · Accepted solution]

@Hanuma_Srikiran,

You may use the following DAX to add a new table and then use the Matrix visual.

Table2 =
UNION (
    SELECTCOLUMNS (
        Table1,
        "ID", Table1[ID],
        "Attribute", DATE ( YEAR ( TODAY () ), MONTH ( TODAY () ) - 1, 1 ),
        "Value", Table1[PREVIOUS MONTH SALES]
    ),
    SELECTCOLUMNS (
        Table1,
        "ID", Table1[ID],
        "Attribute", DATE ( YEAR ( TODAY () ), MONTH ( TODAY () ), 1 ),
        "Value", Table1[CURRENT MONTH SALES]
    )
)

[vanessafvg]

@Hanuma_Srikiran well do you have a date table with the month names?   

[Hanuma_Srikiran]

yes i have