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 Community,
My data set has data quality issues. In the follwoing sample data set, how can I replace end_date 1/01/1900 with end_date from the row where E_key ,Client_key & program are the same but val = 3 & comment is not null:
Many thanks!
Solved! Go to Solution.
@Anonymous , a new column
New column =
var _1 = maxx(filter(Table, [E_key] = earlier([E_key) && [End_date] >date(1900,01,01) ), [End Date] )
return
if( [End_date] = date(1900,01,01), _1, [End_date])
@Anonymous , a new column
New column =
var _1 = maxx(filter(Table, [E_key] = earlier([E_key) && [End_date] >date(1900,01,01) ), [End Date] )
return
if( [End_date] = date(1900,01,01), _1, [End_date])
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 |
---|---|
109 | |
99 | |
77 | |
66 | |
54 |
User | Count |
---|---|
144 | |
104 | |
102 | |
87 | |
64 |