Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
4 years ago
Solved

Get max available date from each month

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

 

 

Need Help
  • amitchandak's avatar
    amitchandak
    4 years ago

    Anonymous , 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)

1 Reply

  • amitchandak's avatar
    amitchandak
    Icon for Super User rankSuper User
    4 years ago

    Anonymous , 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)