Check following threads -
Thanks for the reply, but i am already gone with all threads which you shared but facing one issue. In my scenario sheet1 contains Date and Total from one source and second source contains Date and Total. I have builded relationship between two source files. I want filters on the basis of Week and Month but i am unable to create Week parameter as my datatype is Date.
Your both the queries are different. So, from you reply I have concluded that you want week & month filter. Just create two calculated fields, one is for month name with formula - datename('month',[Order Date]) & one for week - datename('week',[Order Date])
If you want month or week with year & concatenate year with it. datename('month',[Order Date])+' '+datename('year',[Order Date])