Forum Discussion
Hanuma_Srikiran
8 years agoFrequent Visitor
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...
- 8 years ago
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
8 years agoCommunity Champion
Hanuma_Srikiran well do you have a date table with the month names?
Hanuma_Srikiran
8 years agoFrequent Visitor
yes i have