Forum Discussion

robertokzl's avatar
robertokzl
Frequent Visitor
6 years ago
Solved

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 ...
Need Help
  • Anonymous's avatar
    Anonymous
    6 years ago

    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

v-xicai's avatar
v-xicai
Community Support
6 years ago

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.