How to calculate Contribution using DAX - Complex Business Problem - Please help

Thanks Thanks:  0
Likes Likes:  0
Results 1 to 3 of 3

Thread: How to calculate Contribution using DAX - Complex Business Problem - Please help

  1. #1
    New Member
    Join Date
    Nov 2017
    Posts
    2
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Question How to calculate Contribution using DAX - Complex Business Problem - Please help


    How to calculate Contribution using DAX - Complex Business Problem - Please help
    SQL View: a view created from SQL query from different tables
    Unpivot SQL View: and unpivot version of table created in point 1 through power query
    Report : Desired presentation


    Objective: adding contribution column next to sales column where contribution is total sales - total prime cost

    Advice required for above objective


    Following action tried
    With no success - Tried to calculate contribution in seprate colum in sql view an then unpivot renders wrong grouping through unpivot hence the results
    with no success - Tried to calculate measures (wchih can be seen in data model) to achieve objective and then to making sets to delete extra column


    Please follow the link to download model
    https://1drv.ms/x/s!AmJRjgj6xuQ_jQ7zPtvrWzrn05Kv

  2. #2
    MrExcel MVP
    Moderator
    Joe4's Avatar
    Join Date
    Aug 2002
    Posts
    42,713
    Post Thanks / Like
    Mentioned
    16 Post(s)
    Tagged
    2 Thread(s)

    Default Re: How to calculate Contribution using DAX - Complex Business Problem - Please help

    Cross-posted: https://www.excelguru.ca/forums/show...em-Please-help

    While we do not prohibit Cross-Posting on this site, we do ask that you please mention you are doing so and provide links in each of the threads pointing to the other thread (see rule 13 here: http://www.mrexcel.com/forum/board-a...rum-rules.html).

    This way, other members can see what has already been done in regards to a question, and do not waste time working on a question that may already be answered.

    For a more complete explanation on cross-posting, see here: http://www.excelguru.ca/content.php?184).
    TIPS FOR FINDING EXCEL SOLUTIONS
    1. Use the built-in Help that comes with Excel/Access
    2. Use the Search functionality on this board
    3. A lot of VBA code can be acquired by using the Macro Recorder.

    "Give a man a fish, feed him for a day. Teach a man to fish, feed him for life!"

  3. #3
    New Member
    Join Date
    Nov 2017
    Posts
    2
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default Re: How to calculate Contribution using DAX - Complex Business Problem - Please help

      
    Thanks for above advice here is the link to other forum for the same post


    https://forum.powerpivotpro.com/foru...o-please-help/

    https://www.excelguru.ca/forums/show...ed=1#post35472

User Tag List

Tags for this Thread

Like this thread? Share it with others

Like this thread? Share it with others

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  

 

 
DMCA.com