Phase by minth

[AliBb]

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

 

[Joe4]

Duplicate: https://www.mrexcel.com/forum/power-bi/1059133-phasing-month-post5086242.html

Please do not post the same question multiple times. All clarifications, directly-related follow-ups, and bumps should be posted back to the original thread. Per forum rules, posts of a duplicate nature will be locked or deleted (rule 12 here: http://www.mrexcel.com/forum/board-announcements/99490-forum-rules.html).

If you do not receive a response, you can "bump" it by replying to it again, though we advise you not to bump a thread more than once a day.

Also note that Power Pivot questions should be posted to the "Power BI" forum. I have moved your post there.