Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Grow your Fabric skills and prepare for the DP-600 certification exam by completing the latest Microsoft Fabric challenge.

Reply
Paulyeo11
Impactful Individual
Impactful Individual

My sales table and target table have 3 Active link it is okay ?

Hi All

After reading the doc , I still not sure about correct approach. Hope some one can advise me.

Paulyeo11_0-1604266848431.png

 

 

1 ACCEPTED SOLUTION
amitchandak
Super User
Super User

@Paulyeo11 , Question is not clear.

You need to have common dimensions - Country, Staff, and date. ( Or Country/staff and date )

 

In case you do not have common tables, refer to how to create  -https://www.youtube.com/watch?v=Bkf35Roman8

 

View solution in original post

2 REPLIES 2
amitchandak
Super User
Super User

@Paulyeo11 , Question is not clear.

You need to have common dimensions - Country, Staff, and date. ( Or Country/staff and date )

 

In case you do not have common tables, refer to how to create  -https://www.youtube.com/watch?v=Bkf35Roman8

 

Hi Amit

Do you mean i need to combine SOURCE , SALES_PERSON , DATE INTO 1 Field for both table ?

Paul

Helpful resources

Announcements
Europe Fabric Conference

Europe’s largest Microsoft Fabric Community Conference

Join the community in Stockholm for expert Microsoft Fabric learning including a very exciting keynote from Arun Ulag, Corporate Vice President, Azure Data.

RTI Forums Carousel3

New forum boards available in Real-Time Intelligence.

Ask questions in Eventhouse and KQL, Eventstream, and Reflex.