Power Pivot - marking the latest date based on duplicate values

[leemubai]

Dear all,

I have a table with dublicate order numbers in a columnn and individual date in a another column.

I only want to count the order with the most recent date, so I want to mark the order with the most recent date with a "1" in a calculated column. How can I solve it in Power Pivot?

Any idea?

Order	Date	Column1
123​	12.02.2020​	1​
123​	11.02.2020​	0​
525​	01.01.2020​	1​
526​	02.01.2020​	1​
527​	08.01.2020​	1​
527​	19.01.2019​	0​

KR leemubai

 

[citizenbh]

Maybe you didn't rewrite the formula well
Imige:

 

[citizenbh]

Maybe you didn't rewrite the formula well!

Snap1.png

 

[leemubai]

Yes, you are right! It was my mistake! Now it works your formula. Thanks a lot for your time!

 

[citizenbh]

Glad I was able to help!