Thanks for responding! The 7 days is just a placeholder as I indicated in my request. Feel free to use 6 if you'd like.
Yes, I'd like to use log(base 2) for the calculations.
I'm not sure about your question: "Did you mean columns when you wrote columns?" but yes, the four columns presented in the table. The first two are the available data and the last two are what I would like to calculate.
Could you help me walk through your LogN PowerQuery? It's completely new to me. Specifically, I'd like to understand how I can incorporate these pieces of code into my workbook:
Table.FromRows(Json.Document(Binary.Decompress(Binary.FromText("lZFLDoMwDESvUrGuwJ/Y8ZwFcf9rNJUawEAWXVjK4j05nlnXyRZfhISm9/Rq4/X3OGZ7f6maqBhQkSgMKJypSgOKKWE8wjhhMsLkjMXtXprFLDRApRuajA7ut9OsZiXIzbpRng0chpbCIEU37NHYM2kGqzuVuhv+bPBxB5ThWr0bqTrckmo7hCFB2O+IRyOOX7EDYkTcjVQp9Po9mgkubMp9h6R22+qbweJgYZZu8N+G/G2kzlGvETSDggy1tHS3Dw==", BinaryEncoding.Base64), Compression.Deflate)), let _t = ((type nullable text) meta [Serialized.Text = true])