Forum Discussion

Noelle's avatar
Noelle
Icon for Helper I rankHelper I
6 years ago

Lookupvalue before calculate gross margin from variable costs

Hi all,   I have been struggling with this for a while now. I would like to calculate gross margin on revenue with the following setup: - 1 table 'Date' connected to: - 2 sources of orders with e...
Need Help
v-juanli-msft's avatar
v-juanli-msft
Icon for Community Support rankCommunity Support
6 years ago

Hi Noelle 

Check if my pbix satisfy your needs.

Best Regards
Maggie
Community Support Team _ Maggie Li
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

  • Noelle's avatar
    Noelle
    Icon for Helper I rankHelper I
    6 years ago

    Good Morning Maggie v-juanli-msft

     

    I have tried your connexion and measure.

    Variable costs are expressed per product range, and not product code, so I cannot have a 1:* relation between 'product' and 'variable costs'. product range is a group from product code. Let me prepare a sample for you, I guess that will be better than my previous screenshots.

     

    Best regards,

    Noelle

    • Noelle's avatar
      Noelle
      Icon for Helper I rankHelper I
      6 years ago

      • v-juanli-msft's avatar
        v-juanli-msft
        Icon for Community Support rankCommunity Support
        6 years ago

        Hi Noelle 

        Sorry, i don't know what you want finally and what's wrong you meet right now.

        I have reproduce your data model and create a matrix below.

        Please let me know what i need to do next step.

        Best Regards
        Maggie
        Community Support Team _ Maggie Li
        If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.