Power Platform Community Forum Thread Details

Hello everyone,

Question for two tables in the Dataverse.

So, I have this table, 'Person'. Each person has a Region.

Like these columns:

Person: Jim

Region: Europe

Target: 1000

January: Target * 'Region Target %'

I've created a relationship with another table, 'Region Target', using the Region.

This table has these columns:

Region: Europe

January: 0.05

February: 0.1

etc.

Now, how do I create the Person's January formula using the 0.05 value in January in the Region table?

Big thanks in advance!!!

Categories:

Formula column using a column from a related table?