Get max available date from each month

[Shadaiv]

Hi experts,

Need your help here.

We have a requirement of getting the maximum available date for each given month. There are multiple dates available for each month. I want to create a DAX calculated column (flag column) which can set the max available date from each month to 1 and other 0. Here is the sample date and expected output

Thanks

[amitchandak · Accepted solution]

@Shadaiv , A new column

=

var _pay = eomonth([payment Date],0)

return

if( [payment date] = maxx(filter(all(Table), eomonth([payment Date],0)  =_pay), [payment date]) ,1,0)