Forum Discussion

ChrisPBI's avatar
ChrisPBI
Advocate III
10 years ago
Solved

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...
Need Help
  • jahida's avatar
    jahida
    10 years ago

    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.

    Hope that helps!

ChrisPBI's avatar
ChrisPBI
Advocate III
10 years ago

Hi,

 

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

 

Here the result:

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

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's avatar
jahida
Impactful Individual
10 years ago

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.

Hope that helps!