hi friends i want to create a calendar dased on date field.

[#1]

HI friends  i want to create a calendar based on date field but the problem is that date field contains only yyyy-mm.

[jpenuliar]

does this code work on your app?

Date_src:

LOAD

$(Start) + Rowno() -1 as DateId

AUTOGENERATE $(NumOfDays);

[#3]

it is creating problem while linking..will u pls create sample for me ...

[jpenuliar]

Have a look at attached file.

[#5]

thank you jonathan ....

[#6]

did u check the subset ratio....its 1 % in pnl..pls check

[jpenuliar · Accepted solution]

That is because your fact table only has dates Mapped to the First Day of the months, where as the Calendar has all the Dates generated. If you want to match the subset ratio, you will have to delete all the other dates except the first of the month.

Since you will only have 24 rows (2014 to 2015 months) you can probably create an xls version of the Master Calendar and manually input data.