Power Query - Add dates to fixed Data set

I have two tables with two columns:
Table1 - Price
- contract#
- datevalid (2-3 instances a year)
- price (updated when the datevalid changes)

Table2 - Hours
- contract#
- date (each calendar day)
- hours (hours worked on each calendar day)


All I want to do is call the price that's valid for the day worked.

Is this best done in powerquery or powerpivot/dax?

I'm thinking I could create a table3 = rates

Have this down to the detail level:
- contract#
- datevalid
- date: calendarday 1, 2,3..n
- price

This way, I could link this table to table2 by calendarday.

I realize table1=table3, with the only difference being 'date:calendarday1,2,3...n"
- How would you modify a table to do this?