Forum Discussion

AtchayaP's avatar
AtchayaP
Helper V
4 years ago
Solved

Powerbi

 

Anybody help me pls?

 

amitchandak 

Need Help
Show and Tell
Tips and Tricks
  • Hariharan_R's avatar
    Hariharan_R
    4 years ago

    Hi

    You can union those 3 columns into one like below

     

    Union Table =
    UNION (
    SELECTCOLUMNS ( 'Table1', "Value", Table1[Level 4] ),
    SELECTCOLUMNS ( 'Table1', "Value", Table1[Level 5] ),
    SELECTCOLUMNS ( 'Table1', "Value", Table1[Level 6] )
    )

    Thanks

    Hari

    Did I answer your question? Then please mark my post as the solution.
    If I helped you, click on the Thumbs Up to give Kudos.

    My Blog :: YouTube Channel :: My Linkedin


1 Reply

  • Hariharan_R's avatar
    Hariharan_R
    Solution Sage
    4 years ago

    Hi

    You can union those 3 columns into one like below

     

    Union Table =
    UNION (
    SELECTCOLUMNS ( 'Table1', "Value", Table1[Level 4] ),
    SELECTCOLUMNS ( 'Table1', "Value", Table1[Level 5] ),
    SELECTCOLUMNS ( 'Table1', "Value", Table1[Level 6] )
    )

    Thanks

    Hari

    Did I answer your question? Then please mark my post as the solution.
    If I helped you, click on the Thumbs Up to give Kudos.

    My Blog :: YouTube Channel :: My Linkedin