Forum Discussion
Differential for specific values
Hi Power BI team, As usual I need your help to get this sorted. I have this table where the following fields are listed: Basically each Fare Basis value has a specific time len...
hi v-ljerr-msft,
thank you for your feedback....
i've found a solution at the end wich is: calculating every min AIF for each CXR and then making measures QF-CXR in order to highlight differentials.
Hi TheOckieMofoTheOckieMofo,
i'll give it a go and see what happens :)
However AIFs do not need to be summed up as it would be inappropriate: this will be a benchmark tool and we need to understand the position of every competitor for each period...
let me know if it's unclear
You can replace SUM in the formulas to MIN, MAX, AVERAGE, whatever aggregate function makes sense for the data.