Forum Discussion

Regular Visitor

6 years ago

Comparing Columns

Hi, I have 2 tables in my data model & wish to calculate the difference between them Append_All_Boards[Board TCV] & Resign_Append[Access TCV]. The tables are connected by the common field [...

Solution Sage

6 years ago

Can you confirm that you have an active many to one relationship between Append_All_Boards and Resign_Append?

Are you able to include a snip / screen shot of your Relationship view?

Best regards,

Martyn

If I answered your question, please help others by accepting it as a solution.

PMF99
Regular Visitor
6 years ago
Thanks Martyn.

Here you go ...
- MartynRamsden
  Solution Sage
  6 years ago
  Hi PMF99
  
  The RELATED function can only be used on the many side of a many to one relationship.
  In your case, this is the Resign_Append table. Hence why you're seeing the error.
  
  Can you explain in a bit more detail (ideally with some example data) what you're trying to achieve?
  
  Best regards,
  Martyn
  
  If I answered your question, please help others by accepting it as a solution.
  - PMF99
    Regular Visitor
    6 years ago
    Hi Martyn,
    
    Here's the pivot I want to create....
    
    [Board TCV] by [Deal Code] comes from Append_All Boards and gives the correct answer.
    
    [Access TCV] by [Deal Code] comes from Resign_Appends and gives the correct answer.
    
    My issue is I'd like to calculate the Var (variance) in Power Pivot and not manually calculate in Excel as I'm now doing.
    
    Trying to bring the 2 columns together in 1 table to be able to calculate the variance in Power Pivot is what's giving me the problem.
    
    Many thanks
    Peter

Related content