data modelling

[Anonymous]

Site

Branch

BE

STL

DSE Code

DSE Name

Route No.

Retailier Code

Retailer Name

Channel

Channel Type

Sector

Type

Retailing Target Jan'24

document_date

subbrandform_name

Retailier Code

Retailier Code

channel_description

dse

customer_type

category

brand

brandform

quantity

retailing

dse_code

branch_code

branch_name

Month

Fiscal

Site

these are the column names of 2 different table. I'm not able to get exact data mapping and all of these targets are set according to retailing code.  

[Anonymous · Accepted solution]

Hi @Anonymous ,

Could you please provide more raw data(exclude sensitive data)  and the desired result with Text format or screenshot to make a deep troubleshooting?

It would be helpful to find out the solution.

You can refer the following links to share the required info:

How to provide sample data in the Power BI Forum

Looking forward to your reply.

Best Regards