Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
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
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.