Forum Discussion

Hanuma_Srikiran's avatar
Hanuma_Srikiran
Frequent Visitor
8 years ago
Solved

Column Header names should contain current month dynamically

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...
  • v-chuncz-msft's avatar
    8 years ago

    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]
        )
    )