Forum Discussion

Puja's avatar
Puja
Icon for Helper III rankHelper III
3 years ago
Solved

Need help with DAX

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 ...
  • FreemanZ's avatar
    FreemanZ
    3 years ago

    hi Puja 

    try like:

    Table =
    UNION
    (
        SELECTCOLUMN(
           TableName,
           "Date", TableName[Date],
           "A", TableName[A]
        ),
        SELECTCOLUMN(
           TableName,
           "Date", TableName[Date],
           "B", TableName[B]
        )
    )
Puja's avatar
Puja
Icon for Helper III rankHelper III
3 years ago

Hi tamerj1 ,

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

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

 

TIA

tamerj1's avatar
tamerj1
Icon for Community Champion rankCommunity Champion
3 years ago

Puja 

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

  • Puja's avatar
    Puja
    Icon for Helper III rankHelper III
    3 years ago

    Hi tamerj1 ,

    Below solution helped. Thank you for looking into it.