Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
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.
Solved! Go to 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")
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")
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
113 | |
99 | |
75 | |
73 | |
49 |
User | Count |
---|---|
145 | |
109 | |
109 | |
90 | |
64 |