Need to filter Data for Last six weeks from current date

[Anonymous]

Hi Community,

I need to filter out Last 6 weeks data, but I am not getting Relative dates filter may be because of the formt of the field. The data is coming from cube so I cannot modify the column.

I have fields in below format :

27 July 2016 - Calender Date

20160703 - Fiscal Date

 Regards

Divya

[az38]

Hi @Anonymous 

try to create new calculated columns:

Calender Date Column = DATEVALUE(([Calender Date]))

and

Fiscal Date Column = date(left([Fiscal Date];4);MID([Fiscal Date];5;2);right([Fiscal Date];2))

then use them in visuals including sliders

do not hesitate to give a kudo to useful posts and mark solutions as solution

LinkedIn

[Anonymous]

@az38  Thanks for the reply, Now the issue is when i am trying to convert the data type to Datevalue i cannot find the table field Calender date ,It show cannot find name. Any idea's on that

[az38]

@Anonymous
You wrote about field Calender date in the first post. So, you need to create calculate column in the same table as “Calender date” field

[Anonymous]

either Modify existing date column at cube level and change format to date or create new column with required data type.