This site uses different types of cookies, including analytics and functional cookies (its own and from other sites). To change your cookie settings or find out more, click here. If you continue browsing our website, you accept these cookies.
What you have should work! I think what is probably happening is that your Activity_timeframe column is not formatted as a date. You will probably need to use the DateTime Parse tool to convert the field.
It's likely a formatting issue. I'd check if your dates are formatted as dates --- if not, use the DateTime tool to convert them. Once you've verified your dates are good to go, then try adding DateTimeFirstOfMonth() in a formula prior to the filter and setting the Data type to Date. I've had issues comparing Dates to DateTimes, so this might be the cause.
Oh this actually worked, some reason I have to create separately a FirstofMonth type dimension with the Formula tool. Then used that within the filter, which is weird. It's an extra step in the workflow but did work.
I will try anyways your way too Nick just for learning purposes. Thanks again for your help.