How to add the reference line that changes overtime?

[Marie201931]

The dimension is project released month from 09/2018 to 01/2019.

My target is 09/2018: 66%; 10/2018: 99%; 11/2018: 100%; 12/2018: 100%; 01/2019: 100%.

I wrote a load * inline statement to insert two more column in my data. But the target number is not showing in my final table at all.

Table1:
LOAD

ID,

Name,
[Project Development Release Month]
FROM a location
(qvd);
left join(Table1)
load * inline
[Project Development Release Month, Target
09/2018,66%
10/2018,100%
11/2018,100%
12/2018,100%
01/2019,100%];

Thanks for your help.

[sunny_talwar]

The field type for Project Development Release Month in the two tables might not be the same. It might be a Date field within Table1, but Text within the inline load.... may be try this

Table1:
LOAD ID,
  Name,
  [Project Development Release Month]
FROM a location (qvd);

Left Join(Table1)
LOAD Date#([Project Development Release Month], 'MM/YYYY') as [Project Development Release Month],
Target;
LOAD * INLINE [
Project Development Release Month, Target
09/2018,66%
10/2018,100%
11/2018,100%
12/2018,100%
01/2019,100%
];

[petersmith69]

reply is quite helpful.

Try this . it works.

Thank you  the person replying in this thread.quite helpful.

[petersmith69]

reply is quite helpful.

Try this . it works.

Thank you  the person replying in this thread.

quite helpful.