Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
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.
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
114 | |
97 | |
85 | |
70 | |
61 |
User | Count |
---|---|
151 | |
120 | |
103 | |
87 | |
68 |