Power BI Exchange

Please login or click SIGN UP FOR FREE to create your PowerBIUG account to join this user group.
Expand all | Collapse all

Sum from Another Column- Need URGENT Solution

  • 1.  Sum from Another Column- Need URGENT Solution

    Bronze Contributor
    Posted 29 days ago
    Edited by Anubhav Mahule 29 days ago
    Hi Guys, I am stuck in a problem.
    I wish to calculate,


    I have 2 separate Sheets with Tables exactly mentioned below:

    JC | Dealer Name

    &

    JC | Material cost

    Both sheets are in relationship thru JC

    I want to calculate Material cost against each Dealer Name

    Pls Help. Sheet screenshots attchd. Also sharing link of the tables


    ------------------------------
    Anubhav Mahule
    Lead consultant
    ------------------------------
    Academy - Online Interactive Learning from Experts


  • 2.  RE: Sum from Another Column- Need URGENT Solution

    Gold Contributor
    Posted 28 days ago
    Hi. May you please attach the pbix here with your logic, it will be easir to get assistance.

    ------------------------------
    Shungu Dhlamini
    Power BI Consultant
    shungud@gmail.com
    ------------------------------

    Academy - Online Interactive Learning from Experts


  • 3.  RE: Sum from Another Column- Need URGENT Solution

    Bronze Contributor
    Posted 27 days ago
    Edited by Anubhav Mahule 27 days ago
      |   view attached
    @Shungu Dhlamini, Thats a grt piece of advice. Frm nxt time onwards, i will also attch pbi for future queries..Attching as instructed here​

    Also if u see any pro with relationships, pls advice there too

    ------------------------------
    Anubhav Mahule
    Lead consultant
    ------------------------------

    Attachment(s)

    Academy - Online Interactive Learning from Experts


  • 4.  RE: Sum from Another Column- Need URGENT Solution

    Bronze Contributor
    Posted 28 days ago
      |   view attached
    HI Anubhav

    I've attached a small model which might help. I did it in Power Query so the mechanism is the same.

    1. Create a connection only for your two tables
    2. Merge them from the Material cost table using the JC Number as the matching column
    3. Bring through the dealer name only
    4. Group by dealer name
    Hope this helps. I'm happy to provide screen shots if you'd find that useful.

    good luck

    Matthew

    ------------------------------
    Matthew Perren
    Dynamics 365 BC/NAV Consultant
    OneThreeOne Scotland Ltd
    Edinburgh United Kingdom
    +447732 653 849
    ------------------------------

    Attachment(s)

    xlsx
    Anubhav example.xlsx   20K 1 version
    Academy - Online Interactive Learning from Experts


  • 5.  RE: Sum from Another Column- Need URGENT Solution

    Bronze Contributor
    Posted 27 days ago
    Edited by Anubhav Mahule 27 days ago
    Thanks Mr @Matthew Perren for taking such an effort for me.. Surely i will try this method. I think it will work

    ------------------------------
    Anubhav Mahule
    Lead consultant
    ------------------------------

    Academy - Online Interactive Learning from Experts


  • 6.  RE: Sum from Another Column- Need URGENT Solution

    Bronze Contributor
    Posted 27 days ago
      |   view attached
    @Matthew PerrenTried method suggested.. It worked​. Snapshot attchd

    ------------------------------
    Anubhav Mahule
    Lead consultant
    ------------------------------

    Academy - Online Interactive Learning from Experts


  • 7.  RE: Sum from Another Column- Need URGENT Solution

    Bronze Contributor
    Posted 27 days ago
    @Anubhav Mahule Excellent! So glad it worked for you. ​It's always a pleasure to help someone else in the community and I always learn something whilst doing it. Doubtless you'll be helping me next time!

    ------------------------------
    Matthew Perren
    Dynamics 365 BC/NAV Consultant
    OneThreeOne Scotland Ltd
    Edinburgh United Kingdom
    +447732 653 849
    ------------------------------

    Academy - Online Interactive Learning from Experts


  • 8.  RE: Sum from Another Column- Need URGENT Solution

    Bronze Contributor
    Posted 27 days ago
    If i can be of any help, it wud be so great

    ------------------------------
    Anubhav Mahule
    Lead consultant
    ------------------------------

    Academy - Online Interactive Learning from Experts