topic Re: DAX for current year in DAX Commands and Tips

DAX for current year

Anonymous — Wed, 22 Jun 2022 11:12:29 GMT

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 ?

SpartaBI — Wed, 22 Jun 2022 11:51:02 GMT

Anonymous add this calculated column:

Column = IF(YEAR('Table'[Date]) = YEAR(TODAY()), 12 - MONTH('Table'[Date]), 12)

Anonymous — Wed, 22 Jun 2022 12:05:47 GMT

Thank You, This worked perfectly.

SpartaBI — Wed, 22 Jun 2022 12:07:10 GMT

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 🙂