Home Forums Power BI Backward filters with M2M relationship in Power BI

This topic contains 0 replies, has 1 voice, and was last updated by  yacoubi 2 weeks, 2 days ago.

Viewing 1 post (of 1 total)
  • Author
    Posts
  • #11247

    yacoubi
    Participant
    • Started: 1
    • Replies: 0
    • Total: 1

    I have been really struggling with this for the past week. Let me explain what is it that I’m trying to do and maybe you can help:

    • A forecast is made for 1 product only. It has a date and volume to be ordered
    • A product can have many forecasts
    • Each product is made out of many intermediates (ingredients) using percentages totalling to 100%:
      • Example: product A = 15% intermediate 1 + 45% intermediate 2 + 40% intermediate 3

    How can I create a table or chart showing the following:

    monthly volumes for each intermediate (intermediate volume = product volume x intermediate percent for that product)

     

    Below is a snapshot of my current Power BI schema:

    https://i.ibb.co/C0cRnRt/schema.jpg

    Attachments:
    You must be logged in to view attached files.
Viewing 1 post (of 1 total)

You must be logged in to reply to this topic.