Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
3 years ago
Solved

Very tough question - Need help badly!!

I need to create a column of values on a matrix table in Power BI that draws from three different column sources. 

 

First the data table : 

 

 

Here is the mapping table : 

 

 

I need to create a matrix table that has these columns :

 

Net Sales 

Distribution Margin

RnD

SGnA

Division Margin

 

I would have to link the data table to the mapping table using columns Funct_Area and FA.  

 

As you can see I have to use the FA GR L2 column to get the Net Sales, RnD, and SGnA.

 

As you can see by looking at the mapping table, Distribution Margin is a roll-up of Net Sales, Cost of Sales, OMC, and Other COGS.   Division Margin is a rollup of Distribution Margin, RnD, SGnA, and Other Operating.

 

How can create this column that has just Net Sales, Distribution Margin, RnD, SGnA, and Division Margin?  

 

Do I need to create some kind of calculated field, group totals, some new kind of mapping? 

 

I'm at a total loss here and this is my 2nd attempt to get this problem solved from this forum.  Please help me someone!

 

 

Need Help
Tips and Tricks
  • mussaenda's avatar
    mussaenda
    3 years ago

    Hi Anonymous ,

     

    You can use relationship to link the tables and achieve your requirement

2 Replies

  • mussaenda's avatar
    mussaenda
    Community Champion
    3 years ago

    Hi Anonymous ,

     

    You can use relationship to link the tables and achieve your requirement

  • foodd's avatar
    foodd
    Community Champion
    3 years ago

    Hello Anonymous , you posted this in the Desktop Forum, and a moment later cross-posted it to the 

    Power Query Forum.

     

    Members of the Forum are volunteers and give their time to help others.   Please take a moment to 

    read this very important post which is pinned to the top of the Desktop Forum, and applies equally to 

    all of the  Microsoft Power BI Community Forums.  

     

    How to Get Your Question Answered Quickly 

     

    Don't Cross Post

    Cross posting is considered rude and wasteful and it has been so since the dawn of forums. Don't do it. Again, some answerers use the "All Topics" view of the forums and then we see 5 posts with the same title and question. Which one do we answer? Bottom line, some community members will not answer a cross posted topic on principle alone. If you are not sure where to post your question, use the "General" forum.