Cant define term in Q&A where a calendar year nbr = a measure that is the current year

[MKatsanevas]

Hello. Im trying to define a term in Q&A where a calendar year nbr equals a measure that is calculated to current year. I have read that you can use measures in the definitions. I cant seem to get it to work. It does work if I say where fiscal year is CurrentYear. But I want to be able to say give me sales for currentYear and it knows that the fiscal year is the current year. Any help would be appreciated.

[v-xiaotang]

Hi @MKatsanevas 

Thanks for reaching out to us.

I doubt if it is possible, how do you define thisfiscalyear? 

Best Regards,

Community Support Team _Tang

If this post helps, please consider Accept it as the solution to help the other members find it more quickly.

[MKatsanevas]

I fugured it out. I created an is_currentyear_ind that gave me a 1 for true and a 0 for false, instead of the currentyear being a year number. Then I defined the text "CurrentYear" as is_currentyear_ind=1 in the teach Q&A. It worked great.

[MKatsanevas · Accepted solution]

its just a whole number in the calendar.