I have a simple PowerBI dashboard that links to several Excel spreadsheets. I take a cut of data monthly, but want to save and allow the user to select previous iterations using a drop down slicer. What is the simplest way to manage this?
I’m the past I just saved everything in one excel doc and labelled each record with the month it was downloaded but my data sets will quickly grow large this way…
