Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!
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.
@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,
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?
Regards,
User | Count |
---|---|
141 | |
113 | |
104 | |
77 | |
64 |
User | Count |
---|---|
135 | |
123 | |
101 | |
71 | |
61 |