Power Pivot- dynamic data filter

[Barbora Risova]

Hi,
i'm getting data from large data cube and i need just values for last three months from current date. I need data to be filtered on server. I was wondering whether there's a way to make filter dynamic so the range of dates would be from current day to current day -90 days. I searched for answer and since i'm new to this i'm not an expert on MDX statements. Is it possible to do it in Table Import wizard Desgin mode?
Thanks in advanced for any help

 

[olivierhbh]

Hi,
Couldn't you do it in sql?


SELECT * FROM Table_Name
WHERE Date_Column >= DATE_ADD(CURDATE(),INTERVAL -90);

Olivier