Genarate Rows having last date of particular Month

Question

I Only Want Rows which has the last day of the particular month

InputOutput

Test.xlsx

Ladarthure · Answer

Hi @harshal98,

you can use the datetimeformat([date], '%Y%m') to get the year and month. You can then sort your data by month, and by date and finally use a sample tool to get the last row for each month.

Hoipe it helped!

Emil_Kos · Answer

Hi @harshal98,

I have used part of this workflow in order to prepare a solution for you.

https://community.alteryx.com/t5/Alteryx-Designer-Discussions/How-to-find-last-month-last-business-day/m-p/147237/highlight/true#M39212

Date filter.yxmd