Forum Discussion
Anonymous
5 years agoNot applicable
How to make Sales Target Amount = 1 ?
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 ? :-
Anonymous , they should be joined with common date table and you should use date from that date table in visual
2 Replies
- amitchandak
Super User
Anonymous , they should be joined with common date table and you should use date from that date table in visual
- AnonymousNot applicable
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