Forum Discussion

Yazid's avatar
Yazid
Icon for Helper I rankHelper I
2 years ago
Solved

Find max date for each year

Dear,

 

I would like to have a DAX code able to return me the Max date for each year. Example as below:

 

Thanks in advance for your support

Need Help
  • ryan_mayu's avatar
    ryan_mayu
    2 years ago

    Yazid 

    change the start date to date type

     

    then create a column

     

    output = if('Table'[startdate]=maxx(FILTER('Table',year('Table'[startdate])=year(EARLIER('Table'[startdate]))),'Table'[startdate]),'Table'[startdate])
     

3 Replies

  • ryan_mayu's avatar
    ryan_mayu
    Icon for Super User rankSuper User
    2 years ago

    Yazid 

    change the start date to date type

     

    then create a column

     

    output = if('Table'[startdate]=maxx(FILTER('Table',year('Table'[startdate])=year(EARLIER('Table'[startdate]))),'Table'[startdate]),'Table'[startdate])