Forum Discussion
Solved
Number to date
Ok, I'll try it this https://community.powerbi.com/t5/Desktop/Zahl-in-Datum-%C3%A4ndern-Zellen-mit-0-Werten/m-p/3008604#M1026104 in english: I want to change a number into a date. It only works, ...
Broeselchen You can replace with day as 01 if its 00. Use below code for it.
Kagdat_datum = var _day = if(int(RIGHT ( [KAGDAT], 2 ))=0,01,RIGHT ( [KAGDAT], 2 )) return IF ( [KAGDAT] = 0 || [KAGDAT] = BLANK() , BLANK (), DATE ( LEFT ( [KAGDAT], 4 ), MID ( [KAGDAT], 5, 2 ),_day) )
No, there's nothing else.
Broeselchen is it possible for you to share PBIX file after removing sensitive data?
Broeselchen You can replace with day as 01 if its 00. Use below code for it.
Kagdat_datum = var _day = if(int(RIGHT ( [KAGDAT], 2 ))=0,01,RIGHT ( [KAGDAT], 2 )) return IF ( [KAGDAT] = 0 || [KAGDAT] = BLANK() , BLANK (), DATE ( LEFT ( [KAGDAT], 4 ), MID ( [KAGDAT], 5, 2 ),_day) )Oh, now I made the list shorter and it works. So, you're right, there must be something in the dates. How can I finde the problem?
(I can't find a point to upload the csv...)
Broeselchen you can upload it any drive and share it with open access or you can use website like https://wetransfer.com/
Hi Broeselchen , We are getting this error due to you have some date which are 00.
Ok! And do you have any solution for this problem?
Yes!!!! Thank you so much!