Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
7 years ago
Solved

Current Month in date table

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.

  • 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")

     

1 Reply

  • AlB's avatar
    AlB
    Community Champion

    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")