Forum Discussion

Broeselchen's avatar
Broeselchen
Helper III
3 years ago
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, ...
Need Help
  • Samarth_18's avatar
    Samarth_18
    3 years ago

    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)
)
Broeselchen's avatar
Broeselchen
Helper III
3 years ago

Ok! And do you have any solution for this problem?

Samarth_18's avatar
Samarth_18
Community Champion
3 years ago

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)
)