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
ChrisPBI
Advocate II
Advocate II

Getting Year from date.

Hello,

 

I try to get only the year from my date.

 

The function YEAR(date) always deliveres me the sum.

 

Only whe I use a table I can say don't summarize.

 

But the column can't be used for any visual this way.

 

Thanks for helping.

 

Regards,

Chris

1 ACCEPTED SOLUTION
jahida
Impactful Individual
Impactful Individual

Ah ok. Try this:

 

Click on the year column in your data model, go to the Modeling tab at the top, and then go to Default Summarization and select "Do Not Summarize". That should solve many of your problems.

Capture2.PNG

Hope that helps!

View solution in original post

3 REPLIES 3
jahida
Impactful Individual
Impactful Individual

Not quite sure what the objective is. YEAR(Date) is definitely the way to get the year of a date, why isn't that working for you? Do you have a particular use case in mind?

Hi,

 

a use case could be to show the total emissions over the years.

 

Here the result:

 

1.PNG

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

But the result should be a line with the years as X-Axis.

 

I would expect when I do: Release Year = YEAR('Models'[Release Date]) that the resulting column always shows the years without summing everything.

 

Thanks,

Chris

jahida
Impactful Individual
Impactful Individual

Ah ok. Try this:

 

Click on the year column in your data model, go to the Modeling tab at the top, and then go to Default Summarization and select "Do Not Summarize". That should solve many of your problems.

Capture2.PNG

Hope that helps!

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.