Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!
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
User | Count |
---|---|
47 | |
27 | |
23 | |
18 | |
15 |
User | Count |
---|---|
55 | |
34 | |
18 | |
17 | |
15 |