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 month- last month of current year.
For example - If Date is 30/05/2022 then Months column should output= 7
2) if the date is of previous years, then months column output should be 12.
For example - If date is 30/05/2018 or 25/09/2019 etc for all these output months column should always be 12.
Can anyone please help ?
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
3 Replies
- SpartaBI
Community Champion
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- 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 🙂