Forum Discussion
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 ...
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 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