HI friends i want to create a calendar based on date field but the problem is that date field contains only yyyy-mm.
Solved! Go to 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.
its a actual revenue data comes from a web based application monthly , so in date field date is not available is there any way to create calendar for i have to generate only quater month and financial year from this field.
USe makedate() for creating date.
Ankith try this.
Month as date,
YEAR(Month) as Year,
Month(Month) as Months,
Num(Month(Month)) as MonthNumber,
'Q' & ceil(month(Month) / 3) as Quarter
(biff, embedded labels);
Try to load data into the QV without Null values