Using measures for Date column rather than Index col for row context

[JarrettM]

Jarvis,

Here is what I have completed so far. I figured out Value 1, 7 Days Ago & 30 Days Ago Measures. Still working on getting the 30 & 90 Moving Averages. I put each of those measures in the Closing Prices table.
I got a bit creative on adding the Index column. I saw a similar post to this that @Nick_M came up with this solution. If you go into the M code you will se how I grouped the Index number by stock symbol.

Stock Market Dashboard

@AamerMalik Do you have some sample data? Would need it in excel/text/csv since will be doing this in PQ. But high level: Group by stock Order each sub-table from date old to new Add an index column to each sub table Expand the final table out

EDNA- Solution Except Moving Averages.pbix (721.2 KB)

Thanks
Jarrett