Forum Discussion
Matrix table with development with data from 2 different tables
- 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.
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.