Forum Discussion
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 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
hi Anonymous
try like:
Table =UNION(SELECTCOLUMN(TableName,"Date", TableName[Date],"A", TableName[A]),SELECTCOLUMN(TableName,"Date", TableName[Date],"B", TableName[B]))
6 Replies
FreemanZSuper User
hi Anonymous
try like:
Table =UNION(SELECTCOLUMN(TableName,"Date", TableName[Date],"A", TableName[A]),SELECTCOLUMN(TableName,"Date", TableName[Date],"B", TableName[B]))Thank you FreemanZ 🙂
- tamerj1
Community Champion
Hi Anonymous
how many types do you have? Any columns other than date and type are required?
