Filter that sorts dates in DAX

[Jmenas]

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:

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.

[v-yuezhe-msft]

@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,

[Jmenas]

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. 

[v-yuezhe-msft]

@Jmenas,

Why not directly sort the version column to show  the visual?


Regards,