Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
3 years ago

New Calculated Column with Date Calendar Power Query

Hi, I have my table with data and it contains month and year, and I hace created a calendar table with the date. The problem is that I am creating a new table with the reference of the first one, so I need a column with the exact date, how can I create a column with the exact date?

 

It needs to be in Power Query editor, because I am referencing the principal table (table 1)

 

Table 1

 

Table 2

 

 

 

 

Need Help
Show and Tell
Tutorial Requests

2 Replies

  • v-zhangti's avatar
    v-zhangti
    Community Support
    3 years ago

    Hi, Anonymous 

     

    Use Split to separate this column from Year and Month.

    After renaming the column, add the index column.

    Column:

    Date = DATEVALUE([Year]&"/"&[Month]&"/"&[Index])

    Is this the result you expect?

    Best Regards,

    Community Support Team _Charlotte

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

  • Anonymous's avatar
    Anonymous
    Not applicable
    3 years ago

    This will only work if the rows are updated in order, right?

     

    Is there a way to see the date a file was updated to SP?