Earn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.
Hi All,
I'm currently having a problem where the year is displayed incorrect.
Data is valid and set to U.K. date.
I've checked all of the data and there is no discrepencies.
I found another article refering to this same issue here: Solved: Year 2020 displaying as "202" - Microsoft Power BI Community
User was advised to use "Never detect column types and headers for unstructured sources." which made no difference for me.
Any help would be greatly appreicated.
Solved! Go to Solution.
I managed to resolve this by fixing errors in my Excel data.
Dates were entered wrong and formatted incorrectly.
I managed to resolve this by fixing errors in my Excel data.
Dates were entered wrong and formatted incorrectly.
@id7 , how you got this year?
You created like
= year([close Date])
I have it setup like this.
User | Count |
---|---|
98 | |
90 | |
77 | |
71 | |
64 |
User | Count |
---|---|
115 | |
102 | |
98 | |
71 | |
67 |