Forum Discussion
Text comparison with grid output. Help needed!
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 |
5 Replies
Hi,
If you have already created the third column, what further help do you need?
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.
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/38490Hi, 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
