Need help with DAX

[Puja]

Hello All,

Please, I need some help with DAX (not in PQ)

I have a table below

DATE        TypeA   TypeB
1/16/2021  A           B
1/30/2021  A           B
2/13/2021  A           B
2/27/2021  A           B
3/20/2021  A           B

Is there a way I can get a format like this using DAX?

1/30/2021A

DATE	TYPE
1/16/2021	A
2/13/2021	A
2/27/2021	A
3/20/2021	A
1/16/2021	B
1/30/2021	B
2/13/2021	B
2/27/2021	B
3/20/2021	B

Thank you

[tamerj1]

Hi @Puja 

how many types do you have? Any columns other than date and type are required?

[Puja]

Hi @tamerj1 ,

Yes, I do have other columns like Month and Year.

Also, I want the reqested format in the same table.

TIA

[tamerj1]

@Puja 

Would you please update the provided sample perhaps with more realistic data?

[Puja]

Hi @tamerj1 ,

Below solution helped. Thank you for looking into it.

[FreemanZ · Accepted solution]

hi @Puja 

try like:

Table =

UNION

(

    SELECTCOLUMN(

       TableName,

       "Date", TableName[Date],

       "A", TableName[A]

    ),

    SELECTCOLUMN(

       TableName,

       "Date", TableName[Date],

       "B", TableName[B]

    )

)

[Puja]

Thank you @FreemanZ  🙂