topic Re: Dax formula to calculate % Change, and then Conditional Formatting of that result in DAX Commands and Tips

Dax formula to calculate % Change, and then Conditional Formatting of that result

Anonymous — Fri, 17 Jul 2020 19:02:47 GMT

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.

Re: Dax formula to calculate % Change, and then Conditional Formatting of that result

Anonymous — Fri, 17 Jul 2020 19:37:44 GMT

HI Anonymous ,

Assuming 2019.06 and 2020.06 are measures

Create a new measure

PercentChange = DIVIDE([2020.06] - [2019.06] , [2020.06])

Incase 2019.06 and 2020.06 are columns

Create a new measure

PercentChange = DIVIDE(MAX('Table'[2020.06]) - 'Table'(MAX( [2019.06]) , MAX('Table'[2020.06]))

Then Select the 2020.06 Column and Right Click, Select Background Formatting.

From the dropdown Select the measure PercentChange

Regards,

Harsh Nathani

Appreciate with a Kudos!! (Click the Thumbs Up Button)

Did I answer your question? Mark my post as a solution!

Re: Dax formula to calculate % Change, and then Conditional Formatting of that result

Anonymous — Fri, 17 Jul 2020 19:51:14 GMT

2019.06 and 2020.06 are values within a column titled 'Year Mo'

Re: Dax formula to calculate % Change, and then Conditional Formatting of that result

Anonymous — Fri, 17 Jul 2020 19:56:52 GMT

HI Anonymous ,

Share sample Data Please in text form

Regards,

Harsh Nathani