Genarate Rows having last date of particular Month

[harshal98]

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

InputOutput

[Emil_Kos]

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-d...

[Ladarthure]

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!