Forum Discussion

Anonymous

Not applicable

4 years ago

Solved

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...

DAX

power bi

SpartaBI
4 years ago
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

Community Champion

4 years ago

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

Anonymous

Not applicable

4 years ago

Thank You, This worked perfectly.

SpartaBI
Community Champion
4 years ago
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 🙂

Forum Discussion

DAX for current year

Related content

DAX for Financial Year Running Report Employee

YTD last year DAX

Current year YTD and Last year YTD DAX Formula

DAX Last Year Sales

DAX and leap year, date range