Hello! I have come across a challenge I can’t seem to get to work…was wondering if anyone has ever tried this out:
I have slicers on my original dataset where the user can choose a specific date range and a couple of locations they want to view. I now want to create a table with 25 random samples based of the filtered data from the slicers.
Currently, I have been able to get it to work on the original dataset. However, it does not take the slicers into consideration. Does anyone have any advice?
This is how I am creating a new table with 25 random samples from my original table called “Query1”.