Earn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.
I have a date column in SharePoint list which a query is retrieving. I have created a calculated column -
Solved! Go to Solution.
Year() will produce a numeric column. The default summarize by behaviour for a numeric column is to sum it. So 14133 is probably 2019 * the number of rows in your table. You can change this behaviour by clicking on the column then changing the "Default Summarization" property in the modelling ribbon in Power BI.
If you change it to "Do not summarize" Power BI will effectively do a "group by" and just show the distinct values for the year.
Year() will produce a numeric column. The default summarize by behaviour for a numeric column is to sum it. So 14133 is probably 2019 * the number of rows in your table. You can change this behaviour by clicking on the column then changing the "Default Summarization" property in the modelling ribbon in Power BI.
If you change it to "Do not summarize" Power BI will effectively do a "group by" and just show the distinct values for the year.