Forum Discussion
DAX for current year
I am struggling to get this going. So I have a date column which contains all the dates from 2018 till today. Now my requirement is 1) If the date is of current year, then months column= Date mon...
Anonymous add this calculated column:
Column = IF(YEAR('Table'[Date]) = YEAR(TODAY()), 12 - MONTH('Table'[Date]), 12)
In case it answered your question, please accept the solution to help other members find it. Appreciate Your Kudos.
SpartaBI Logo
Visit SpartaBI website Visit SpartaBI Linkdin Visit SpartaBI Facebook
Showcase Report – Contoso By SpartaBI
Thank You, This worked perfectly.
SpartaBI
Community Champion
Community ChampionAnonymous my pleasure 🙂 Happy to help.
Please check out my showcase report - got some high level stuff there..
https://community.powerbi.com/t5/Data-Stories-Gallery/SpartaBI-Feat-Contoso-100K/td-p/2449543
Give it a thumbs up over there if you liked it 🙂