Forum Discussion
Next event
Hello all,
I'm trying to find a method to display header title as return of a next event search.
I have a dataset with format below:
| Customer | kickoff meeting | Design | Prototype | SOP |
| Customer 1 | 10 May. 2020 | 2 Jul. 2020 | 15 Aug. 2020 | 23 Nov. 2020 |
| Customer 2 | 2 Jan. 2020 | 10 Apr. 2020 | 30 Jun. 2020 | 10 Aug. 2020 |
And i need to get table with customer and next milestone (30 days ahead from current date), like this:
| Customer | Next Milestone | Date |
| Customer 1 | Design | 2 Jul. 2020 |
| Customer 2 | Prototype | 30 Jun. 2020 |
Thanks,
Hi robertokzl ,
You can make it using the unpivot table function in Power Query Editor.
1. In Power Query Editor, right-click the customer column, choose unpivot other columns, then the table change to :
2. Create a measure :
Measure 17 = CALCULATE(MAX('Table (5)'[Attribute]),FILTER('Table (5)','Table (5)'[Value] >= TODAY() && 'Table (5)'[Value] <= TODAY() + 30))Aiolos Zhao
3 Replies
Hi robertokzl ,
You can make it using the unpivot table function in Power Query Editor.
1. In Power Query Editor, right-click the customer column, choose unpivot other columns, then the table change to :
2. Create a measure :
Measure 17 = CALCULATE(MAX('Table (5)'[Attribute]),FILTER('Table (5)','Table (5)'[Value] >= TODAY() && 'Table (5)'[Value] <= TODAY() + 30))Aiolos Zhao
Hi robertokzl ,
You may enter into Query Editor, select on the columns Design and Prototype at the same time, right click to choose option "Unpivot Columns" . Then you may rename the result column Attribute with "Next Milestone", rename Value with "Date", don’t forget to click button "Close & Apply".
Best Regards,
Amy
Community Support Team _ Amy
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Many Thanks,
That's exactly what i loking for!
