Forum Discussion

damit23183's avatar
damit23183
Microsoft Employee
5 years ago
Solved

Index ID from Date Column using Power Query

Hi,   I have a Date Column and would like to create INDEX column based on Date values.   For example;   I have Date Column as show in below figure and from Date Column I want to create ID (Inde...
Need Help
  • amitchandak's avatar
    amitchandak
    5 years ago

    damit23183 , Create a new column like

    Date.ToText([Date], "yyyyMMdd")

amitchandak's avatar
amitchandak
Super User
5 years ago

damit23183 , Create a new column like

Date.ToText([Date], "yyyyMMdd")

damit23183's avatar
damit23183
Microsoft Employee
5 years ago

Thanks Amit it worked.

 

 

Thanks