I have a report where I need to calculate daily sales * production / monthly production. I get it by flattening three tables this model (here's the file, in case you would like to take a look):
... into this model, using Power Query:
It works a lot faster than the original SUMIFS and...