Variable 1/2021 - current month

Legacy Contributor

Hi,

does anyone know if it is possible to create a variable from beginning of the year to the current month and use that in dashboard?

Meaning that I would have a time.year/month embedded filter in dashboard and months 1/2021 - 6/2021 are ticked by default and next month also 7/2021 is selected automatically.

Thanks in advance!

Dan Rosen

Hey Tomi, you can try these:

Year/Month from beginning of year:

SELECT Format(DateTime(Format([Time.Date],'1/1/yy')),'yyyy')+'/'+Format(DateTime(Format([Time.Date],'1/1/yy')),'MM') FROM [ALL] WHERE [Time.Days Ago] = 0

Year/Month from current month:

SELECT Format(DateTime(Format([Time.Date],'1/m/yy')),'yyyy')+'/'+Format(DateTime(Format([Time.Date],'1/m/yy')),'MM') FROM [ALL] WHERE [Time.Days Ago] = 0