Extract date from source

[Aydeedglz]

Hi I want to extract the date from the source document, I have already created a table calendar and it extracted the data from there, but I want a COLUMN not a TABLE

Here I have column for year and month that are inclouded in the report, but I also need the Date

TABLE 1

TABLE 2

My calendar table was able to extract it. FullDate is only a concatenated column from month and year from first table, so I want to have the same "Date" column in my table 1, WITH POWER QUERY

Thanks

[v-jialluo-msft · Accepted solution]

Hi  @Aydeedglz ,

You can try to solve the question by adding a calculated column

DAY = 'CALENDAR'[Date].[Day]

Final output

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