Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!

Reply
Saswa_D
Frequent Visitor

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 ? 

1 ACCEPTED SOLUTION
SpartaBI
Community Champion
Community Champion

@Saswa_D add this calculated column:

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


2022-05-19 17_30_22-Re_ Need help on DAX function with measure vs colu... - Microsoft Power BI Commu.png


Full-Logo11.png

SpartaBI_3-1652115470761.png   SpartaBI_1-1652115142093.png   SpartaBI_2-1652115154505.png

Showcase Report – Contoso By SpartaBI

View solution in original post

3 REPLIES 3
SpartaBI
Community Champion
Community Champion

@Saswa_D add this calculated column:

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


2022-05-19 17_30_22-Re_ Need help on DAX function with measure vs colu... - Microsoft Power BI Commu.png


Full-Logo11.png

SpartaBI_3-1652115470761.png   SpartaBI_1-1652115142093.png   SpartaBI_2-1652115154505.png

Showcase Report – Contoso By SpartaBI

Thank You, This worked perfectly. 

SpartaBI
Community Champion
Community Champion

@Saswa_D 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 🙂

Helpful resources

Announcements
April AMA free

Microsoft Fabric AMA Livestream

Join us Tuesday, April 09, 9:00 – 10:00 AM PST for a live, expert-led Q&A session on all things Microsoft Fabric!

March Fabric Community Update

Fabric Community Update - March 2024

Find out what's new and trending in the Fabric Community.

Top Solution Authors