Forum Discussion

ColinCowan's avatar
ColinCowan
Helper I
3 years ago
Solved

Replace Numbers with Date Sequencial

Hi, hoping someone can help my aim is to replace the numbers with the specified date after each date change.  
Need Help
  • ColinCowan's avatar
    ColinCowan
    3 years ago

    Hi, thanks that works and easier much appreciated.

     

    Regards Colin

  • v-yanjiang-msft's avatar
    v-yanjiang-msft
    3 years ago

    Hi ColinCowan ,

    My pleasure!

    If it works, would you mind accept it as solution? Then more people who have the same requirment will find the solution quickly and benefit here, thank you!

     

    Best Regards,
    Community Support Team _ kalyj

ColinCowan's avatar
ColinCowan
Helper I
3 years ago

Greg

 

Error code

 

 

Greg_Deckler's avatar
Greg_Deckler
Community Champion
3 years ago

ColinCowan No, that's not the formula I posted, the formula for your added column is:

try DateTime.FromText([Column1 - Copy]) otherwise null

Your added column formula is literally not that. At all. Your formula doesn't include the try statement or the otherwise. See PBIX attached below signature.

 

 

  • ColinCowan's avatar
    ColinCowan
    Helper I
    3 years ago

    Greg

     

    Thanks Can I reset as I am now confussed should the formula be

     

     

    • v-yanjiang-msft's avatar
      v-yanjiang-msft
      Community Support
      3 years ago

      Hi ColinCowan ,

      Another way maybe easy to understand for you.

      1.Select the column then click Data Type option.

      2.Select Date/Time.

      3.Then you will find the numbers return error, right-click the column and select Replace Errors.

      4.Enter null in the dialog.

      5.Select the column, then click Fill Down.

      Result:

      I attach my sample below for your reference.

       

      Best Regards,
      Community Support Team _ kalyj

      If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

       

       

       

      • ColinCowan's avatar
        ColinCowan
        Helper I
        3 years ago

        Hi, thanks that works and easier much appreciated.

         

        Regards Colin