Help, how d I get % change?

Hi bv27718n,

Couple Suggestions:

1. Create a Region table that contains the State and Region it belongs to, then join that table to your facts, use the Region table to filter the fact data

2. Either Union your 2020 and 2021 data together and add a period column, more extensible as you add more periods || or created calc columns using lookups in the 2021 table to get the 2020 data you want to compare for each row, not as extensible for additional years.

If you are able to provide sample data as opposed to screen shots that would be very helpful.

Thanks,