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?
Bookmarks