Forum Discussion

sabilahmed's avatar
sabilahmed
Icon for Resolver I rankResolver I
4 years ago
Solved

Calculated column from one table to another table

Hello,   I desperately need help with the following problem.   I have a calculated column in table "Config" which counts the number of instances per IV_Product_RecID (as there are "many" rows wit...
Need Help
  • sabilahmed's avatar
    sabilahmed
    4 years ago

    I've done it:

     

    Created a calculated column in v_rpt_product:

     

    Count_IV_Product_RecID = COUNTROWS(RELATEDTABLE(Config))
Anonymous's avatar
Anonymous
Not applicable
4 years ago

Have you tried merge queries in power query?

sabilahmed's avatar
sabilahmed
Icon for Resolver I rankResolver I
4 years ago

Yes - I mentioned that above, but it didn't work. Due to the nature of the calculation it doesn't appear as one of the columns to expand in the merge.

 

I'm thinking a better way to solve this issue is if I rephrase my questions to this:

How can I create a calculated column in my Config table to return the count of IV_Product_RecID from v_rpt_product table?

 

Remember:

Config has MANY ID's

v_rpt_product has UNIQUE ID's per row

 

Therefore this is a ONE-MANY relationship.