Case 967 How to link sales table with target table ?

[Paulyeo11]

Hi All

Can some one share with me sample PBI file on sales and target.

As I have 3 Table , i need to link them up , so that i can compute sales vs target in one table and give correct value.

Expected Result :-

My raw data and PBI file :-

https://www.dropbox.com/sh/39wicbv0s06601n/AABTPEdsxof2co-e6RGnfDxKa?dl=0

Paul

[amitchandak · Accepted solution]

@Paulyeo11 , One date is April and one date is in March.

Please find the attached model, Create Date, Source and Group table.  Joined those.

Create a visual

[Paulyeo11]

Hi Amit

Thank you very much , finally i understand how to link.

Do you have document link for me to read.

Paul

[Paulyeo11]

Hi Amit

Thank you for sharing with me.

When i apply to my actual doc , The target amount alway 201.

Error msg below :-

Column '' in Table '' contains blank values and this is not allowed for columns on the one side of a many-to-one relationship or for columns that are used as the primary key of a table.

Gope you can take a look

Paul