Calculated Columns Missing from Independent Table

[Deermeat]

Hello,

I'm trying to create a heatmap with different tiles across where each row is controlledby different set of slicers. Previously, when I wanted to do this with line graph, I was recommended to use New Table = 'Old Table' to create an indepedent table for the slicers to work (Link). I've used this method to create 2 new tables: Data1 and Data2. The original table is Data. 

To find the month on month average, I used calculated columns to find the previous score and then the % change:

However, the two calculated columns that I created are not appearing in the independent table, instead appearing as blank.

Do you know how to fix this so that the calculated columns are brought over as well?

[v-henryk-mstf]

Hi @Deermeat ,

Is your question about recreating a separate table that contains the calculated column created by the referenced table?

Everything seems to work fine in my tests.

Can you further describe the data model you created or provide the relevant test files so that I can do further testing?

Looking forward to your reply.

Best Regards,
Henry

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.