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)
SpartaBI
Community Champion
Community ChampionAnonymous add this calculated column:
Column = IF(YEAR('Table'[Date]) = YEAR(TODAY()), 12 - MONTH('Table'[Date]), 12)
Thank You, This worked perfectly.
- SpartaBI
Anonymous 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 🙂