Forum Discussion

Dave's avatar
Dave
Icon for Advocate I rankAdvocate I
10 years ago
Solved

DAX Year() Not Returning the Year

I have gotten some unexpected results when using DAX Year() - the year isn't returned in some cases. As a comparison, I created a new column the query editor, which always returned the correct value....
  • fbrossard's avatar
    fbrossard
    10 years ago

    Hi @Dave,

    When you adding a calculated column using Year() DAX function, it builds an integer a column.

    And by default, all integer cols are summarized by using sum, that's why you have the total under your year column.

    Open you model, select your table and "year" column, go to "Modeling" menu and change the property "Default Summarization" from "Sum" to "Do not summarize"

     

     

fbrossard's avatar
fbrossard
Icon for Kudo Commander rankKudo Commander
10 years ago

Hi @Dave,

When you adding a calculated column using Year() DAX function, it builds an integer a column.

And by default, all integer cols are summarized by using sum, that's why you have the total under your year column.

Open you model, select your table and "year" column, go to "Modeling" menu and change the property "Default Summarization" from "Sum" to "Do not summarize"

 

 

  • Greg_Deckler's avatar
    Greg_Deckler
    Icon for Community Champion rankCommunity Champion
    10 years ago

    Brilliant, didn't eve see that.

    • fbrossard's avatar
      fbrossard
      Icon for Kudo Commander rankKudo Commander
      10 years ago

      Thx Greg_Deckler.

      @Dave, sometimes you could have an integer column that of want to sum by default.

      Nevertheless, you can modify the aggregation function at any time for any visual just by picking it :

       

  • Dave's avatar
    Dave
    Icon for Advocate I rankAdvocate I
    10 years ago

    Thank you much! Setting the "Default Summarization" to "Do Not Summarize" resolved my issue. Also, thanks for all input on when to use M vs DAX.