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"

     

     

ImkeF's avatar
ImkeF
Icon for Community Champion rankCommunity Champion
10 years ago

You can find some performance aspects of M vs DAX here:

 

https://blog.oraylis.de/2016/02/relative-week-column-with-dax-power-query/

 

"...Actually the Power Query version is slightly faster, because the Vertipaq-Engine can do a better compression with a column which is set during data load. The DAX generated columns will be created during processing the model. This has two negative impacts. First the compression won’t be as good and second every time the cube is processed, for example when a new measure is created, Power BI Desktop will recreate the two columns, which will take more time..."