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.
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
It’s time for another PBI Community recap!
Visit our Community Blog for articles, guides, and information created by fellow community members.
Need help with the Power BI Community? Our 'Using the Community' support articles are a great place to start.
Looking for inspiration on how to present your data? Need instructional videos? Check out our Galleries!