Current Month in date table

[Anonymous]

Hello everybody, 

I built a date table for my report and now I want to show a column in this to show the current month...

This table goes from 1/1/2000 from 1/1/2050 because will be using this in the future. 

I want a column in this table that shows "Mes Actual" in case month is the current month or "Historico" in case month is not the current month. 

I tried with a calculated column

CM = if('calendar'[Mes]=MONTH(today()),"Mes Actual", "Histórico")

but in this case it shows "mes actual" in february of every year and I need to show this only in februay of 2019. 

Hope you can help me. 

Thank You.

[AlB · Accepted solution]

Hi @Anonymous

You're almost there.  Just need to include the year in the condition:

CM = if('calendar'[Mes]=MONTH(today()) && 'calendar'[Año]=YEAR(today()),
         "Mes Actual", "Histórico")