New Calculated Column with Date Calendar Power Query

[Aydeedglz]

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

[Aydeedglz]

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?

[v-zhangti]

Hi, @Aydeedglz 

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.