I'd appreciate all of your inputs on an issue I'm facing - I'm trying to create a new column from date field restricting it to last 30 days or so. Like you can see in my image, any older date shows up as N/A and I don't want it to come up when creating dashboards.
I need the date column for when I want to change filter options to show all of the dates available in my dataset, I also need the added functionality of showing only last 30 days (dates)
I tried the IFDATETIME (isnull([Last30Days]),createdate(9999,12,31),[Date]),
but then again, I don't also want the 12/31/9999 option showing up in visualization.
How can I model this in the cube?
Please sign in to leave a comment.