Trying to Return Current Date

[Anonymous]

Hi Everyone,

I'm trying to return the current year and last year in a new column. However, when I try creating a DAX formula, it keeps either giving me an error or giving me a random year:

ThisYear/LastYear =

var lastyear = (YEAR(TODAY()) - 1)

var thisyear = (YEAR(TODAY()))

return

IF('Date'[Year] = thisyear, FORMAT(thisyear, "yyyy"), "NA"

)

I tried using SWITCH but that doesn't work. Any advice would be greatly appreciated.

Thanks!

[ValtteriN · Accepted solution]

Hi,

Include the bolded DAX in your FORMAT and you are good to go:

ThisYear =

var _ty = YEAR(TODAY())

return

if('Calendar'[Year]=_ty,FORMAT(date(_ty,1,1),"YYYY"),"NA")

I hope this post helps to solve your issue and if it does consider accepting it as a solution and giving the post a thumbs up!

[ValtteriN · Accepted solution]

Hi,

Include the bolded DAX in your FORMAT and you are good to go:

ThisYear =

var _ty = YEAR(TODAY())

return

if('Calendar'[Year]=_ty,FORMAT(date(_ty,1,1),"YYYY"),"NA")

I hope this post helps to solve your issue and if it does consider accepting it as a solution and giving the post a thumbs up!

[Anonymous]

Thank you! Can you explan what the bolded portion is doing just so I understand?

[ValtteriN]

@Anonymous 

So basically FORMAT recognizes your "YYYY" as date formatstring and for this to work properly you need to pass a "date" to it. Now we create a proper date in this case 1.1.2022 and take the year portion of this with FORMAT to our column.

[Anonymous]

And would you know why this isn't working when I change it to switch? I'd like it to display values for This Year and Last Year

[ValtteriN · Accepted solution]

For both use this kind of structure:

ThisYear + LY =

var _ty = YEAR(TODAY())

var _ly = _ty-1

return

SWITCH(TRUE(),'Calendar'[Year]=_ty,FORMAT(date(_ty,1,1),"YYYY"),

'Calendar'[Year]=_Ly,FORMAT(date(_Ly,1,1),"YYYY"),

"NA")

SWITCH + TRUE is a useful combo

[Anonymous]

Thank you so much!