The ultimate Fabric, Power BI, SQL, and AI community-led learning event. Save €200 with code FABCOMM.
Get registeredCompete to become Power BI Data Viz World Champion! First round ends August 18th. Get started.
Hi,
i need to create a colum that asigne a value based on other 3 columns.
for example, i have this data table
ID | Date | Type |
100 | 01-01-2021 | 1 |
100 | 02-01-2021 | 2 |
100 | 03-01-2021 | 1 |
100 | 05-01-2021 | 3 |
101 | 02-01-2021 | 1 |
101 | 04-01-2021 | 2 |
101 | 03-01-2021 | 3 |
102 | 05-01-2021 | 1 |
102 | 10-01-2021 | 1 |
102 | 11-01-2021 | 1 |
I need to create a new column that for each same ID and type it, assign a letter (from "a" to "z") depending on which came first.
The result should be something like this
ID | Date | Type | New Column |
100 | 01-01-2021 | 1 | 1.a |
100 | 02-01-2021 | 2 | 2.a |
100 | 03-01-2021 | 1 | 1.b |
100 | 05-01-2021 | 3 | 3.a |
101 | 02-01-2021 | 1 | 1.a |
101 | 04-01-2021 | 2 | 2.a |
101 | 03-01-2021 | 3 | 3.a |
102 | 05-01-2021 | 1 | 1.a |
102 | 10-01-2021 | 1 | 1.b |
102 | 11-01-2021 | 1 | 1.c |
Thanks
Solved! Go to Solution.
Hi @rodfernandez ,
Find attached the pbix file with my proposal.
EDIT: Re attached again removing some unnecessary steps and adding List.Buffer.
Hi @rodfernandez ,
Find attached the pbix file with my proposal.
EDIT: Re attached again removing some unnecessary steps and adding List.Buffer.
Perfect, Thanks