Filter out upcoming months

Hello Guys,

I have attached an Excel file. My problem is actually relatively simple i think, so it probably won't be difficult for you. I would like to filter out all coming months that would not be relevant for my Excel.

So for example: It's September and i'm creating a list for August. My goal is to contain only specific rows that really occurred in August. The column with the important month in this case is "K".

Do you have a solution for me? Thanks in advance!

Best Regards,

Christian

Test Dokument.xls

Developer Tools

Accepted answers

caltang

Hi @Rayyl Christian,

You can try the following as attached.

For Christian.yxwz

All comments

caltang

Hi @Rayyl Christian,

You can try the following as attached.

For Christian.yxwz

caltang

Basically, what I've done is made a filter that calls the month that you want to analyse based on the dates in Column K.

Now, the code is:

DateTimeFormat([Inv#-Rel# date],"%B") = "August"

Where %B references the full name of the month based on the date you have in Column K.

caltang

I've also made it into an analytic app for you so that you can play with the interface and choose one of the months of your interest to browse or export. Now, this requires some configuration on your own end to make it as dynamic as you'd like, but it gives you an idea of what is possible on Alteryx. Happy solving!

Quick Links

This months top contributors

atcodedog05 19458

Qiu 15866

binu_acs 15708

MarqueeCrew 13708

apathetichell 13703