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?
Eg
start date = 1/1/2018
end date = 30/6/2019
today = 1/6/2018
Value per day = 50
Pivot would return
Year 2018
June 30 x 50 = 1500
July 31 x 50 = 1550
Aug 31 50 = 1550
etc
Year 2019
Jan
Feb
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?
Eg
start date = 1/1/2018
end date = 30/6/2019
today = 1/6/2018
Value per day = 50
Pivot would return
Year 2018
June 30 x 50 = 1500
July 31 x 50 = 1550
Aug 31 50 = 1550
etc
Year 2019
Jan
Feb