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

Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!

Reply
Jmenas
Advocate III
Advocate III

Filter that sorts dates in DAX

Hi all,

 

I want to create a filter that can be used for sorting the end dates and start dates of my articles. 

 

I created this measure to sort the max date (latest):

 

Latest EndtDate Article = CALCULATE(MAX('Table'[EndDateLatest]), 

FILTER(ALL('Table'),'Table'[ArticleNumber] = MAX('Table'[ArticleNumber])))

 

 My data looks like this:

 

Articles.PNG

 

What I expect is something like 


ArticleA 5     05-01-17     03-02-17 5
ArticleA 4     04-01-17     02-02-17 4
ArticleB 4     05-02-17     07-03-17 4

and so on.

Thanks,

J.

3 REPLIES 3
v-yuezhe-msft
Employee
Employee

@Jmenas,

I am not quite sure that how you sort your table, do you want to sort the rows by Version(5,4,4,3,3,2,2,1,1)? If so, how do you sort the EndDate when the version is same for some Artiles?

Besides, I don’t see the ArticleNumber  column in your sample data.


Regards,

Community Support Team _ Lydia Zhang
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

Hi @v-yuezhe-msft,

 

the idea is to sort them out in a way that I see article  ArticleA5, then ArticleB4 and so on. the idea is to have a list of the latest articles and the end dates. 

@Jmenas,

Why not directly sort the version column to show  the visual?
1.PNG

Regards,

Community Support Team _ Lydia Zhang
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

Helpful resources

Announcements
April AMA free

Microsoft Fabric AMA Livestream

Join us Tuesday, April 09, 9:00 – 10:00 AM PST for a live, expert-led Q&A session on all things Microsoft Fabric!

March Fabric Community Update

Fabric Community Update - March 2024

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