topic Re: Need help with DAX in DAX Commands and Tips

Need help with DAX

Puja — Sun, 05 Mar 2023 01:14:24 GMT

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

Thank you

FreemanZ — Sun, 05 Mar 2023 02:29:46 GMT

try like:

Table =

UNION

(

SELECTCOLUMN(

TableName,

"Date", TableName[Date],

"A", TableName[A]

SELECTCOLUMN(

TableName,

"Date", TableName[Date],

"B", TableName[B]

)

tamerj1 — Sun, 05 Mar 2023 08:09:58 GMT

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

Puja — Sun, 05 Mar 2023 12:03:54 GMT

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

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

TIA

tamerj1 — Sun, 05 Mar 2023 12:15:49 GMT

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

Puja — Sun, 05 Mar 2023 12:51:53 GMT

Thank you FreemanZ 🙂

Puja — Sun, 05 Mar 2023 12:53:16 GMT

Below solution helped. Thank you for looking into it.