Case 969 It there a way to link sales and target table with out need to create 3 more table ?

[Anonymous]

Hi All

I am very happy to get below table model for link sales and target table from below post :-

https://community.powerbi.com/t5/Desktop/Case-967-How-to-link-sales-table-with-target-table/m-p/1469...

It there any short cut which i don't need to create 3 more table ? So that my Table model viewer is more neat.

Paul Yeo

[amitchandak]

@Anonymous , if source and group are kinds of parent child, you could have created a concat key

New Key = [Source] & " "  & [Group]

And the create only one tavle for both with source, Group, and New key and joined back on new key. Date should always be separate

Refer these : https://www.sqlbi.com/articles/the-importance-of-star-schemas-in-power-bi/

https://www.sqlbi.com/blog/marco/2017/10/02/why-data-modeling-is-important-in-powerbi/

[Anonymous]

Hi Amit

I have follow your instruction to create new link field for sales and target table , and i join then up. now my issue is i get warning msg , may i know it is serious ?

My PBI file :-

https://www.dropbox.com/s/ciq9nvwi32wkwo8/TARGET_V010%20Final%20SOLUTION.pbix?dl=0

[Anonymous · Accepted solution]

@Anonymous - It is for the many to many relationship. Watch this video from guy in a cube to understand it- https://www.youtube.com/watch?v=ZrANsDNnZug

[Anonymous]

Hi Sir

Thank you for sharing the video. it help me.

Paul Yeo