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.
Hello There,
I have been searching for how to solve the DATE have wrong data type or the result is too large or too small, however couldn't get mine solved.
My case is i only want the date that have the current Year, current month and the Day of my Start date column. i have tried the below:
i tried to the same with my Dim Date and it working fine. i am not sure what wrong with my start date column.
Could anyone help me with this please ?
Thanks
Solved! Go to Solution.
are there any null values in the date column?
If the date is null, day() can't return the whole number and you can build the new date column
Proud to be a Super User!
you are welcome
Proud to be a Super User!
are there any null values in the date column?
If the date is null, day() can't return the whole number and you can build the new date column
Proud to be a Super User!
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 |
---|---|
110 | |
94 | |
81 | |
66 | |
58 |
User | Count |
---|---|
150 | |
119 | |
104 | |
87 | |
67 |