DAX code for Current Year +1

Topic

New Reply

Hello,

I’m working in Microsoft Visual Studios in a Tabular Model…  I’m trying to make the follow DAX code be variable, so that it will only pull data from the current year -3.  Below is what works when I hard code it… I’d like to change the 2019 to be NOW or TODAY or CURRENT… but those don’t seem to work.  Any help is appreciated!

Thank you!

SELECT [dbo].[DIM Time].* FROM [dbo].[DIM Time] WHERE [Year] = 2019-3

Reply | Quote

Replies

I know nothing of DAX or this coding, but does this reference at all help?

That is, needing to convert data type between text and numeric?

Also see here and this.

Reply | Quote