Formula to show only YTD values

[NorbertB]

Hello I'm pretty new to Alteryx and probably my question may seem very basic but.... My data set consists of monthly data for the whole 2022 year but I would like to create the formula which would enable me to see only YTD data. How to achieve?

[atcodedog05]

Hi @NorbertB 

Can you provide some sample input and expected output It will help us get a better understanding of the usecase.

We will be happy to help : )

[Qiu]

@NorbertB 
Maybe you are just looking for the function of "DateTimeToday()"? 😁

[NorbertB]

I would like to have shown values only for the past months, so in 2022/02 only 2022/01, in 2022/03 only 2022/01 and 2022/02 and so on

[atcodedog05 · Accepted solution]

Hi @NorbertB 

Here is how you can do it.

Workflow:

Hope this helps : )

[NorbertB]

Fantastic. Thanks!

[atcodedog05]

Happy to help : ) @NorbertB 

Cheers and have a nice day!