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.
Go to Solution.
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")
View solution in original post
Join us in the third Triple A event!
It’s the start of a new Super User season! Learn all about the new Super Users and brand-new tiered recognition system.
Make sure you didn't miss any of the things that happened in the community in January!