Power Bi | DAX Unpivot into Calculated Table (Public)

PHOTO EMBED

Tue Nov 30 2021 04:42:57 GMT+0000 (UTC)

Saved by @Darkleech #vba

Table = 
FILTER(
    UNION(
        SELECTCOLUMNS('Table1',"Name",[Name],"Date",[Date],"Column1",[Column1]),
        SELECTCOLUMNS('Table1',"Name",[Name],"Date",[Date],"Column1",[Column2]),
        SELECTCOLUMNS('Table1',"Name",[Name],"Date",[Date],"Column1",[Column3]),
        SELECTCOLUMNS('Table1',"Name",[Name],"Date",[Date],"Column1",[Column4]),
        SELECTCOLUMNS('Table1',"Name",[Name],"Date",[Date],"Column1",[Column5]),
        SELECTCOLUMNS('Table1',"Name",[Name],"Date",[Date],"Column1",[Column6])
    ),
    [Column1]<>"")
content_copyCOPY

*Note – Datatypes must be un Text format. Can filter by column created by the DAX expression itself.

https://community.powerbi.com/t5/Quick-Measures-Gallery/DAX-Unpivot/td-p/574832