Date Comparison

[JImAyers]

Why does this conditional column:

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

Produce this results:

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	10/17/2017 0:00	0

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

[JImAyers]

That resolved it. Thank you 10 to the millionth!

[jaideepnema]

Hi @JImAyers ,
Very weird but Have you tried using :

SCIndicatornew = IF(MIN('Table'[CCA])>'Table'[SessionCodes],0,1)

Please accept this as a solution if your question has been answered !!

Appreciate a Kudos 😀

[amitchandak · Accepted solution]

@JImAyers ,  Try a new column

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 )