Join us at FabCon Atlanta from March 16 - 20, 2026, for the ultimate Fabric, Power BI, AI and SQL community-led event. Save $200 with code FABCOMM.
Register now!The Power BI Data Visualization World Championships is back! Get ahead of the game and start preparing now! Learn more
I have a table below where I need to find the occurances where the Application status changes from Incomplete to complete for the same application ID's on the same day.
| Date | Application ID | Outcome | Application Start Time | Application End TIme | Occurrence |
| 30-06-2021 | 123456789 | Incomplete | 30-06-2021 15:44 | 30-06-2021 15:53 | |
| 02-07-2021 | 123456789 | Incomplete | 02-07-2021 14:57 | 02-07-2021 15:04 | |
| 02-07-2021 | 123456789 | Complete | 02-07-2021 14:57 | 02-07-2021 15:04 | 1 |
| 30-06-2021 | 234567891 | Incomplete | 30-06-2021 15:44 | 30-06-2021 15:53 | |
| 02-07-2021 | 234567891 | Incomplete | 02-07-2021 14:57 | 02-07-2021 15:04 | |
| 03-07-2021 | 234567891 | Complete | 03-07-2021 14:57 | 03-07-2021 15:04 | 0 |
Solved! Go to Solution.
@NoviceBloke12 , Create a new column like
var _max = maxx(filter(Table, [Application ID] = earlier([Application ID]) && [Application End TIme] < earlier([Application End TIme]),[Application End TIme])
var _st = maxx(filter(Table, [Application ID] = earlier([Application ID]) && [Application End TIme] =_max && [date] = earlier([date]) ),[Outcome])
return
if([Outcome] = "Complete" && [Outcome] = "Incomplete", 1, 0)
@NoviceBloke12 , Create a new column like
var _max = maxx(filter(Table, [Application ID] = earlier([Application ID]) && [Application End TIme] < earlier([Application End TIme]),[Application End TIme])
var _st = maxx(filter(Table, [Application ID] = earlier([Application ID]) && [Application End TIme] =_max && [date] = earlier([date]) ),[Outcome])
return
if([Outcome] = "Complete" && [Outcome] = "Incomplete", 1, 0)
The Power BI Data Visualization World Championships is back! Get ahead of the game and start preparing now!
Check out the November 2025 Power BI update to learn about new features.
| User | Count |
|---|---|
| 59 | |
| 46 | |
| 42 | |
| 23 | |
| 18 |
| User | Count |
|---|---|
| 193 | |
| 123 | |
| 99 | |
| 67 | |
| 49 |