In Power Pivot I have a table with
contract start date , contract end date , Value per day
I would like to create a pivot that gives me value per month outstanding based on todays date Is this possible?
start date = 1/1/2018
end date = 30/6/2019
today = 1/6/2018
Value per day = 50