Forum Discussion

ColinCowan's avatar
ColinCowan
Icon for Helper I rankHelper 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
Icon for Helper I rankHelper I
3 years ago

Greg

See result

 

 

 

ColinCowan's avatar
ColinCowan
Icon for Helper I rankHelper I
3 years ago

Greg, I tried this also

 

 

 

 

 

  • ColinCowan's avatar
    ColinCowan
    Icon for Helper I rankHelper I
    3 years ago

    Greg

     

    Error code

     

     

    • Greg_Deckler's avatar
      Greg_Deckler
      Icon for Community Champion rankCommunity 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
        Icon for Helper I rankHelper I
        3 years ago

        Greg

         

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