Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and more. Get started

Reply
Yazid
Helper I
Helper I

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:

Yazid_0-1718122634212.png

 

Thanks in advance for your support

1 ACCEPTED SOLUTION
ryan_mayu
Super User
Super User

@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])
 
11.PNG




Did I answer your question? Mark my post as a solution!

Proud to be a Super User!




View solution in original post

3 REPLIES 3
ryan_mayu
Super User
Super User

@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])
 
11.PNG




Did I answer your question? Mark my post as a solution!

Proud to be a Super User!




Thank you !

you are welcome





Did I answer your question? Mark my post as a solution!

Proud to be a Super User!




Helpful resources

Announcements
July 2024 Power BI Update

Power BI Monthly Update - July 2024

Check out the July 2024 Power BI update to learn about new features.

July Newsletter

Fabric Community Update - July 2024

Find out what's new and trending in the Fabric Community.

Users online (1,535)