Dynamic formula/select help

[TSP]

Hi everyone.

Could someone help me with a challenge I'm facing...

My data has many fields corresponding to months. It also has a [Year] and a [Month] field which relates to when the report was generated.

I'd like to create a new [This Month] field that takes the [year] and [month], and returns the correct field. 

This needs to be dynamic as the Year and Month change and I don't want to re-write my formula each month.

I've included as screenshot of the sample data, and the [This Month] field i'd like to create.

Many thanks,

🙂

[fmvizcaino]

Hi @TSP ,

Here is a suggestion for you using dynamic tools.

Let me know if this works for you.

Best,

Fernando Vizcaino

[Qiu]

@TSP 
Something like this?

[TSP]

Thanks @fmvizcaino , however the month in question is specified by the [Year] and [Month] fields rather than relating to DateTimeToday, if that makes sense?

[pedrodrfaria]

Hi @TSP 

See attached below for the workflow using a transpose and join logic:

Pedro.

[fmvizcaino]

Hi @TSP ,

Sure. That is why I'm using the left function before. Left(datetimetoday(),7) equals to yyyy-mm.

See example attached.

Best,

Fernando V.