Forum Discussion
Date table column to show Dynamic Most-Recent entry date up until next entry date
If data is setup the way you have shown above then you can do the following:
1: Go to Transfrom Data (Power Query)
2: In the Dates table select "Merge Queries" on Forecast Period on both tables. (as shown below)
3: Expand the merged query and select "Forecast Period":
4: Go to Transform tab on the top ribbon and select Fill Down
5: Select "Close and Apply". Now you have your desired output.
Resolver IIIf data is setup the way you have shown above then you can do the following:
1: Go to Transfrom Data (Power Query)
2: In the Dates table select "Merge Queries" on Forecast Period on both tables. (as shown below)
3: Expand the merged query and select "Forecast Period":
4: Go to Transform tab on the top ribbon and select Fill Down
5: Select "Close and Apply". Now you have your desired output.
Thank you so much! I was way overthinking it