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.
Hi All i am using a Direct Query and for the YEAR i am using YEAR(ORDERDATE) AS ORDERYEAR, i even tried DATEPART(YEAR,ORDERDATE) AS ORDERYEAR. The dataset shows the data correctly, but in the report when i tried using in a table, all the years are getting added up. The order year is showing as (2016+2017+2018+2019=8070). Please advice.
Solved! Go to Solution.
Are you able to change the year column to text? Alternatively you should be able to set the Default Summarization to "Do not summarize".
got i tcast to nvarchar(4) and worked.
Thanks
No i cannot change it to text and my default summarization is set to "dont summarize" and is greyed out.
Thanks
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 |
---|---|
104 | |
101 | |
79 | |
72 | |
64 |
User | Count |
---|---|
143 | |
109 | |
103 | |
82 | |
74 |