Forum Discussion

Karthik12's avatar
Karthik12
Icon for Post Patron rankPost Patron
3 years ago
Solved

Matrix table with development with data from 2 different tables

Hello Team, I have to develop one matrix table with Customer - Plan - Actual Plan comes from 1 table, actual production comes from table 2 and customer is available in both table as like below Tab...
  • sturlaws's avatar
    3 years ago

    Hi, Karthik12,

     

    you need to work a little with your data model:

     

    1. create a customer table, with all customers from both of your table. This you can do with power query(transform data)

    2. create a date table, this you can do with DAX, using this code:

    Dates = GENERATESERIES(date(2020,1,1),date(2025,12,31),1)

     

    Then create relationships between your tables:

     



    And now use customer from the customer-table and date from the dates-table on axis and slicers.

     

    I would recommend reading a little about modelling, either google power bi modelling or startt out with this article:
    Power BI Data Modeling | Step by Step Guide with Examples (wallstreetmojo.com)

     

    Cheers,
    Sturla

    If this post helps, then please consider Accepting it as the solution. Kudos are nice too.