Fabric is Generally Available. Browse Fabric Presentations. Work towards your Fabric certification with the Cloud Skills Challenge.
Im looking to either do this in DAX or Power query to create a new table where some of the colums need to become a row and duplicate some of the information in the row against the column.
Maybe easier to show in the example
Original Data | |||||||||
Name | Status | Rating | Score | ID1 | ID2 | ID3 | ID4 | ID5 | Date |
ABC | Expired | Low | 130 | 23452 | 12123 | 1231 | 31224 | 1/01/2020 | |
EFG | Accepted | High | 15 | 4567 | 1/01/2020 | ||||
HIJ | Accepted | Medium | 120 | 678 | 908 | 1/01/2020 | |||
KLM | Accepted | High | 110 | 1/01/2020 | |||||
Outcome | |||||||||
No | Name | Status | Rating | Score | Date | ||||
23452 | ABC | Expired | Low | 130 | 1/01/2020 | ||||
12123 | ABC | Expired | Low | 130 | 1/01/2020 | ||||
1231 | ABC | Expired | Low | 130 | 1/01/2020 | ||||
31224 | ABC | Expired | Low | 130 | 1/01/2020 | ||||
4567 | EFG | Accepted | High | 15 | 2/01/2020 | ||||
678 | HIJ | Accepted | Medium | 120 | 3/01/2020 | ||||
908 | HIJ | Accepted | Medium | 120 | 4/01/2020 |
Solved! Go to Solution.
Hi @MdJ83 ,
You can below steps to achieve the required outcome,
Thanks!
Inogic Professional Services Division
Power Platform and Microsoft Dynamics 365 CRM Development – All under one roof!
Drop an email at crm@inogic.com
Services: http://www.inogic.com/services/
Power Platform/Dynamics 365 CRM Tips and Tricks: http://www.inogic.com/blog/
Hi @MdJ83 ,
You can below steps to achieve the required outcome,
Thanks!
Inogic Professional Services Division
Power Platform and Microsoft Dynamics 365 CRM Development – All under one roof!
Drop an email at crm@inogic.com
Services: http://www.inogic.com/services/
Power Platform/Dynamics 365 CRM Tips and Tricks: http://www.inogic.com/blog/
Check out the November 2023 Power BI update to learn about new features.
Read the latest Fabric Community announcements, including updates on Power BI, Synapse, Data Factory and Data Activator.
Join us for a free, hands-on Microsoft workshop led by women trainers for women where you will learn how to build a Dashboard in a Day!