Expand periodic data or create DAX formula

DAX DAX Calculations
4

One of DAX or Power Query (or perhaps both) can get you there I’m sure. Can you please provide your work-in-progress PBIX for the forum members to see how far you’ve gotten?
Greg