YazidHelper I2 years agoSolvedFind 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 Show Moreryan_mayu2 years agoYazid 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])
ryan_mayu2 years agoYazid 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])
ryan_mayu2 years agoYazid 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])
ryan_mayuSuper User2 years agoYazid 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])
YazidHelper I to ryan_mayu2 years agoThank you !ryan_mayuSuper User to Yazid2 years agoyou are welcome
Related contentFind Most Recent Date Relative to another Date Column in Power QueryFind if a date changesFind Overlapping DatesFind overdue dates this monthFinding required date.
Helper IHelper I
Helper I
