IF STAMENT TO MAKE A FLAG ON A TABLE

[Anonymous]

hello can someone help me please

here what i want to do

i wrote a if statement to display in a column 1 or 0

if the date = to max date it should put 1 else 0

= IF('DATE DE DEMANDE'[DATE] = LASTDATE('DATE DE DEMANDE'[DATE]);1;0)

but i'm getting 1 on all the column

[Anonymous · Accepted solution]

=
var __thisDate = 'DATE DE DEMANDE'[DATE]
var __lastDateInTable = MAX( 'DATE DE DEMANDE'[DATE] )
return
	1 * (__thisDate = __lastDateInTable )

[Anonymous]

thank you for your help 🙂

[Anonymous]

Thanks for giving Kudos 🙂

Best
D

[Anonymous]

Do you want to mark as 1 the last day in each year? In each month? Or only the very last date in the table? What's the logic?

Best
D

[Anonymous]

hello
i want to mark the very last date on the table as 1
like as you cas see the last date on the table is 19/02/2020 it should be mark as 1
juste that the table with grow and each time i'm on the max date  it should have 1 and the rest 0