Forum Discussion

querylearner11's avatar
querylearner11
Regular Visitor
4 years ago
Solved

Extrapolating "Rent amount" from start & end date & amount

Hey, first post in this community! Saw a lot of great helps on the forum, but haven't seen something like this. Currently have data on Lease ID (contract) and Customer ID (customer), with start/end ...
Need Help
lbendlin's avatar
lbendlin
Icon for Super User rankSuper User
4 years ago

See attached for a solution proposal that uses only Power Query, a crossjoin, and calculated columns.

  • querylearner11's avatar
    querylearner11
    Regular Visitor
    4 years ago

    This is great! Thank you for helping out