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.
First post here. So let me know if I do anything incorrect.
I have a sales fact table with daily dates. I'm trying to filter out all the days from the most previous month-end to current. For example: Today is 12/9. I want to return all the dates from (12/1 to 12/9). I've tried a handful of similar forum posts but nothing seems to work correctly.
Is this normally this difficult in Alteryx or is their a simple solution that is eclipsing me?
You should be able to do this in 2 tools (or possibly even 1)! See attached solution illustrating both!
2 tool option (if you have today's date already in your data somewhere):
1. Formula tool to derive the first day of the month: DateTimeTrim([TodayDate],"month")
2. Generate Rows tool to create a record for every date between StartDate and TodayDate, using StartDate as your Initialization point and then DateTimeAdd([Date],1,"day") to iterate until you get to TodayDate
1 tool option (will generate all dates without an input if you're just wanting to do this every time based on today's date when workflow is run):
1. Generate Rows tool starting with DateTimeTrim(DateTimeToday(),"month") to get you start of the month based on today's date, and then same process as above, using DateTimeToday() as your ending condition.