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 All,
As per the title, what I'm trying to acheive in a calculated column is find the first entry of a column value ('flowName') for a group of rows (grouped by 'uniqueId'), and populate this found value into a new column ('firstFlow')
So for example, heres a sample set of existing data with a uniqueId, dateTime and flowName.
uniqueId | dateTime | flowName | firstFlow |
1111A | 2022-03-01 10:01 | Flow Alpha | Flow Alpha |
1111A | 2022-03-01 10:02 | Flow Beta | Flow Alpha |
1111A | 2022-03-01 10:05 | Flow Gamma | Flow Alpha |
2222B | 2022-03-01 12:34 | Flow Delta | Flow Delta |
2222B | 2022-03-01 12:35 | Flow Omicron | Flow Delta |
2222B | 2022-03-01 12:56 | Flow Alpha | Flow Delta |
2222B | 2022-03-01 13:10 | Flow Omega | Flow Delta |
3333C | 2022-03-01 14:22 | Flow Gamma | Flow Gamma |
3333C | 2022-03-01 14:47 | Flow Alpha | Flow Gamma |
What I'm trying to acheive is the column result in Blue.
Thanks in advance,
Jeff.
Solved! Go to Solution.
@jeff_h , a new column
New Column =
var _max = minx(filter(Table, [uniqueId] = earlier([uniqueId]) ) ,[dateTime])
return
maxx(filter(Table, [uniqueId] = earlier([uniqueId]) && [dateTime] =_max) ,[flowName])
@amitchandak can this be used when month changes, and source is used a get from folder
@jeff_h , a new column
New Column =
var _max = minx(filter(Table, [uniqueId] = earlier([uniqueId]) ) ,[dateTime])
return
maxx(filter(Table, [uniqueId] = earlier([uniqueId]) && [dateTime] =_max) ,[flowName])
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.
User | Count |
---|---|
43 | |
23 | |
21 | |
15 | |
15 |
User | Count |
---|---|
45 | |
31 | |
30 | |
18 | |
17 |