Earn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.
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
Solved! Go to Solution.
=
var __thisDate = 'DATE DE DEMANDE'[DATE]
var __lastDateInTable = MAX( 'DATE DE DEMANDE'[DATE] )
return
1 * (__thisDate = __lastDateInTable )
=
var __thisDate = 'DATE DE DEMANDE'[DATE]
var __lastDateInTable = MAX( 'DATE DE DEMANDE'[DATE] )
return
1 * (__thisDate = __lastDateInTable )
thank you for your help 🙂
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