cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
TLW Occasional Visitor
Occasional Visitor

Can I create a column that contains a column value multiplied by a value in an unrelated table?

I'm very new to Power BI, but I love its capabilities.

 

I have a table that contains a column (ACT_Score) which contains values from a related table.Power BI Reference Table.jpg

 

I want to create a new column (or measure) in the table above that multiplies the values in ACT_Score by an integer (ACTTestRatePref) found in an unrelated table (see below)

Power BI Account Info Table.jpg

 

 Is this possible? The need to is scale up the values in ACT_Score by this integer in an unrelated table.  Thanks in advance.

 

 

 

 

 

2 REPLIES 2
Sean Super Contributor
Super Contributor

Re: Can I create a column that contains a column value multiplied by a value in an unrelated table?

You can use LOOUPVALUE to get the value from an unrelated table

 

However I'm unclear about your requirement exactly - can you post some sample data or a link to a sample file?

 

You can also look at my responce here

http://community.powerbi.com/t5/Desktop/Retrieve-a-value-of-a-column-from-another-table/m-p/137064#M...

 

HTH! Smiley Happy

Moderator v-sihou-msft
Moderator

Re: Can I create a column that contains a column value multiplied by a value in an unrelated table?

@TLW

 

In this scenario, since your account_info only have one row, it will not be one-to-one mapping to your Reference rows. So if you want your entire column multiples ACTTestRatePref from that table, just directly multiply by 6 in your calculated column. You don't need to LOOKUPVALUE() function, and it seems there's no searching column between your two tables for using this function.

 

Regards,

Helpful resources

Announcements
New Topics Started Badges Coming

New Topics Started Badges Coming

We're releasing new versions of the badge that everyone's talking about. ;) Check your inbox for notifications.

MBAS 2020

Save the new date (and location)!

Our business applications community is growing—so we needed a different venue, resulting in a new date and location. See you there!

Difinity Conference

Difinity Conference

The largest Power BI, Power Platform, and Data conference in New Zealand

Top Solution Authors
Top Kudoed Authors (Last 30 Days)