cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
mduchesne
Frequent Visitor

Sorting based on milestone dates

I thought this was simple but now I'm utterly confused

My current project shows orders by milestone date/times. these dates are linked back to a date calendar by delivered date. The effect of this is to sort the table by our delivered date.  

 

table, Date selected June 1st, 2018

 

Dates and Milestones.PNG

 

I've got a request asking if they can have a slicer that will sort by a different milestone..OK!?

 

What I tried and Failed

I created additional columns that returned dates for the specific milestones. Then created inactive relationships for my date calendar and created a new modified measure.

base measure,

Measure 1

milestone = max(enteredOnDate)

Measure 2

Arrival= calculate ([milestone], userelationship(milestone,calendar[date)).

 

I expected This (manually created for illustrative purposes)

Dates and Milestone Goal.PNG

 

A milestone table sorted by Arrival/Pickup showing all other relevant dates but I ended up with this below. 

A table filtered to only Arrival/Pickup dates...

 

Modified Milestone.PNG

 

 

I'm missing something obvious here.

please help.

 

Thanks!

 

 

 

 

0 REPLIES 0

Helpful resources

Announcements
PBI_User Group Leader_768x460.jpg

Manage your user group events

Check out the News & Announcements to learn more.

Welcome Super Users.jpg

Super User Season 2

Congratulations, the new Super User Season 2 for 2021 has started!

Community Connections 768x460.jpg

Community & How To Videos

Check out the new Power Platform Community Connections gallery!