Forum Discussion
Transpose multiple columns into one columns
Please help
| What I have | |||||
| Create Date | Assign Date | Modify Date | Complete Date | Sign Date | Receive Date |
| 1/11/2018 | 1/16/2018 | 1/26/2018 | 2/25/2018 | 2/4/2018 | 12/19/2017 |
| 1/12/2018 | 1/17/2018 | 1/27/2018 | 2/26/2018 | 2/5/2018 | 12/20/2017 |
| What I want to Achieve without using DAX but in Power Query | |||||
| 1/11/2018 | |||||
| 1/16/2018 | |||||
| 1/26/2018 | |||||
| 2/25/2018 | |||||
| 2/4/2018 | |||||
| 12/19/2017 | |||||
| 1/12/2018 | |||||
| 1/17/2018 | |||||
| 1/27/2018 | |||||
| 2/26/2018 | |||||
| 2/5/2018 | |||||
| 12/20/2017 |
For more context, I just wanto filter out the latest date in the table and use it as my end date. Thank you in advance
Hello Anonymous ,
what you do is the following:
select all the columns then in the unpivot columns option, select the unpivot only selected columns and it will be like the following screenshot
then you remove the attribute column and rename the value column as you want
If I answered your question, please mark my post as solution, Appreciate your Kudos 👍
Follow me on Linkedin
Vote for my Community Mobile App Idea 💡
2 Replies
Hello Anonymous ,
what you do is the following:
select all the columns then in the unpivot columns option, select the unpivot only selected columns and it will be like the following screenshot
then you remove the attribute column and rename the value column as you want
If I answered your question, please mark my post as solution, Appreciate your Kudos 👍
Follow me on Linkedin
Vote for my Community Mobile App Idea 💡