Custom Column to detect # of Days in Column Headings with Dates

[programsam]

Similar to a question below, I'm trying to:

1. detect columns with dates in the header
2. look at the most recent 3 months (this is dynamic as a new month is added every month)
3. calculates the # of days within the prior 3 months
4. calculates the average number of units per day in the prior 3 months.

As example

 

[programsam]

Since there were no takers, I think maybe I need to update the question. Visually, here's what I'm trying to accomplish.

 

[smozgur]

The update still doesn't explain more about what you are looking for compared to the list in the original question.
Note: If this is a question related to another question that you posted and received an answer to, then you should better provide a link to that thread, so we can take a look at it.

However, this is what I can guess from the existing material and the description so far.
You have the following data:

And you want to convert it to the following:

Where the months before the current month will show the daily units according to the day count in the associated month. For example, 50/30 = 1.666 for April 2023. The current month will show the original value.

As a model, this doesn't make any sense to me, so I didn't even analyze the "prior 3 months" part yet, but this is what I can guess so far.

The code that transforms the data as shown above is:

let
    Source = Table.FromRows(Json.Document(Binary.Decompress(Binary.FromText("i45WclTSUTI1ABImliDCGEgYgwgjA6VYnWglJyDTDCRtbABjmUC5IGlnGN8IWQbMAkm7wPhgwtwAZheQiI0FAA==", BinaryEncoding.Base64), Compression.Deflate)), let _t = ((type nullable text) meta [Serialized.Text = true]) in type table [Product = _t, #"April 2023" = _t, #"May 2023" = _t, #"June 2023" = _t, #"July 2023" = _t, #"August 2023" = _t]),
    Result = Table.FromRecords(Table.TransformRows(Source,
    (r) => Record.TransformFields(r, 
        List.Transform(Record.FieldNames(r), each {_, (i) => try if Date.IsInCurrentMonth(Date.From(_)) then i else Number.From(i) / Date.DaysInMonth(Date.From(_)) otherwise i}))))
in
    Result

I am aware this might not be the desired result, but perhaps you can provide more information by looking at how I explained the source and result above.