Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
5 years ago
Solved

Text lookup between two columns to sum values

Hi All,   You have all been proven to be much smarter than me lately. I appreciate anyone who can help with this.. basically I have the below table which is bills of material. The first column is t...
Need Help
  • v-lionel-msft's avatar
    v-lionel-msft
    5 years ago

    Hi Anonymous ,

     

    Please refer to my .pbix file.

     

    Best regards,
    Lionel Chen

    If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

Anonymous's avatar
Anonymous
Not applicable
5 years ago

amitchandak v-lionel-msft parry2k 

 

I have attached a test file which shows exactly what I am trying to accomplish. Can any of you help? Again, I really appreciate your time. Below is a snip of what is in my test file. 

 

Power BI Test File 

v-lionel-msft's avatar
v-lionel-msft
Icon for Community Support rankCommunity Support
5 years ago

Hi Anonymous ,

 

Please refer to my .pbix file.

 

Best regards,
Lionel Chen

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.