Search code examples
powerbidaxdata-analysispowerbi-desktopdaxstudio

Pivot rows into column using DAX code in DAX Studio

enter image description here

Can anyone help me with code to do a "transpose" function in DAX using DAX Studio (From Image 1 to Image 2)

Image 1 Image 2

enter image description here

Solution 
  • Table 2 = 
ADDCOLUMNS(
    SUMMARIZE('Table', 'Table'[AreaName]),
    "Jan", CALCULATE( SUM('Table'[AreaCount]) , TREATAS( {"Jan"},'Table'[Month])),
     "Feb", CALCULATE( SUM('Table'[AreaCount]) , TREATAS( {"Feb"},'Table'[Month]))
)

    enter image description here