Pivot rows into column using DAX code in DAX Studio

Question

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

Answer 1

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