Dax formula to calculate % Change, and then Conditional Formatting of that result
This is sort of a compound problem: I have a data table that contains the vacancy by geography and time period. I have a matrix visualization that shows that vacancy in two time periods. I would like to calculate the % change between only those two time periods, and then apply background conditional formatting to only the 2020.06 column of a color range of highest to lowest, and sort the table by the % change of highest to lowest. The two time periods: 2019.06 and 2020.06 % Change = (The vacancy of 2020.06 - the vacancy of 2019.06) / (the vacancy of 2020.06) This is the matrix table.
