Call out current month

[NirH_at_BITeam]

Hi,

I need help with something that might be easy to resolve.

I have 3 columns:

Date - Starting 01/01/2017, 01/02/2017, 01/03/2017... till 12/31/2019

Month - January, February, March etc...

Short Month Desc - Jan, Feb, Mar

I need to have a measure that will call out the current month (assuming we are in December) and will indicate: "Dec".

Next month of course it will be "Jan" (regardless the year).

And one more thing... without using Format functionality. I need it to be generic so I can call out any variation of the current month even in a different language.

Thanks!

NH  

[v-qiuyu-msft · Accepted solution]

Hi @NirH_at_BITeam,

You can create a measure below: 

Current month = LOOKUPVALUE('Calendar'[Short Month],'Calendar'[Date],TODAY())

Best Regards,
Qiuyun Yu 

[NirH_at_BITeam]

Can't believe it is as that simple... 

Thank you!