How to make Sales Target Amount = 1 ?

[Paulyeo11]

Hi All

My PBI File :-

https://www.dropbox.com/s/p8tbwesezxo0e6e/TARGET_V008%20Final.pbix?dl=0

Target Table :-

Sales Table :-

May i know how to make Target for 1 Jan 2010 = 1 instead of 3 ? :-

[amitchandak · Accepted solution]

@Paulyeo11 , they should be joined with common date table and you should use date from that date table in visual

[Paulyeo11]

Hi Amit

I have create a master calendar , and link the date to sales and target table , Now the Target amount still wrong ?

https://www.dropbox.com/s/x48vbfnmsydjnci/TARGET_V009%20Final.pbix?dl=0