Text comparison with grid output. Help needed!

[ScORE]

I have two columns in the same table that I compare; current and prior week.  I have created a column in the same table that compares these columns and puts a label into a new column Change from prior week. 

I want to visually display the change from prior week results in a table that has my regions and offices on rows.  I need to show how they've changed from the prior week; if they have Less risk, more risk, same, etc. by counts, for example how many have less risk, etc.  I'm stuck and cant figure out how to make this work in the table.  I created a column for change from prior week, but I'm thinking I need a measure or calculated column and perhaps an additional table with a key?? 

Current week	Prior Week	Change from Prior Week
Low	Low	Same
Medium	Medium	Same
High	High	Same
Medium	High	More Risk
Low	High	Significantly More Risk
Low	Medium	More Risk
High	Medium	Less Risk
High	Low	Significantly Less Risk
Medium	Low	Less Risk

[v-cazheng-msft]

Hi, @ScORE 

Is your problem solved? Are the columns ‘Regions’ and ‘Offices’ in the same table with the columns ‘Current Week’ and ‘Prior Week’? Do you need a Calculated column or Measure to count ‘Change from Prior Week’  based on Regions and Offices? Can you share a sample without sensitive data?

Best Regards,

Caiyun Zheng

[parry2k]

@ScORE it is a bit confusing, if you already have 3rd column as @Ashish_Mathur  mentioned, what else exactly you need. Can you throw an example and explain? Read this post to get your answer quickly.

https://community.powerbi.com/t5/Community-Blog/How-to-Get-Your-Question-Answered-Quickly/ba-p/38490...

[ScORE]

I'm trying to show movement.  For example, I want to show If it was low risk last week, but is now high risk. I would like to show this in a table.  

[Ashish_Mathur]

Hi,

If you have already created the third column, what further help do you need?

[parry2k]

@ScORE so you want this 3rd column as the output?