Forum Discussion
Add trend column to the table
Hi Guys, I need your help with following problem. I have a table that looks like this: YQ 2023-2 2023-3 2023-4 2024-1 2024-2 2024-3 Based on context filter other col...
Hi Anonymous ,
According to your description, here's my solution.
1.Add an index column in Power Query.
2.Create a measure.
Measure = 100 - ( MAX ( [Index] ) - MINX ( ALLSELECTED ( 'Table' ), 'Table'[Index] ) ) * 20Get the correct result:
I attach my sample below for your reference.
Best regards,
Community Support Team_yanjiang
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
I tried with INDEX, but don't know how to use it properly. Most examples I found was related to the metrics values, so it was a part of CALCULATE, I have only text values 2023-2, 2023-3 etc.