Working on a project but getting a little lost. Not sure if I’m not structuring the raw data correctly, or if I’m not thinking the DAX correctly. I’ve done simular reports comparing data over time with a date table and that worked out but this is a bit diffrent.
I’ve attached a PowerBI pbix file. I really simplified the data I’m really working with, but the cals and the idea is still there. Can you take at what I’m doing, direct me or perhaps add some calcs to the NewShinyCalcs table, add an new tab and repost. The pbix is only 230Kb.
Further text details explaining the issues are in the pbix file.