Seeking Date Greater than the previous date

[anwilkins]

Question is:

Why does this conditional column:

SCIndicator = if (MIN('MERGE_BillingSUMMARY'[SessionCodes]) > ('MERGE_BillingSUMMARY'[CCA]) ,1,0 )

Produce this results:

 Where the first two SessionCodes (10/4/2017 and 10/11/2017) are clearly not > 10/17/2017.

Patient Internal Id	CCA	SCIndicator	SessionCodes
185763		1
185763		1	10/4/2017 0:00
185763		1	10/11/2017 0:00
185763		1	11/1/2017 0:00
185763		1	11/28/2017 0:00
185763		1	12/11/2017 0:00
185763		1	1/16/2018 0:00
185763		1	1/29/2018 0:00
185763		1	2/26/2018 0:00
185763		1	3/7/2018 0:00
185763		1	3/21/2018 0:00
185763		1	4/10/2018 0:00
185763		1	4/25/2018 0:00
185763	10/17/2017 0:00	0

[amitchandak · Accepted solution]

@anwilkins , Try a new column like

Column =

var _min = minx(filter(Table, [Patient Internal Id] =earlier([Patient Internal Id]) && not(isblank([CCA])) ),[CCA])

return

if ('MERGE_BillingSUMMARY'[SessionCodes] >_min ,1,0 )

[anwilkins]

Hey Amitchandak, I had to do a bit more configuration but yes...this did get me the first date, now I need the second date. If you will refer to this link, you will see the entire request in a different post.

Pull the next sequential service date that use spe... - Microsoft Power BI Community