Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
I am currently working on an app that will have several sheets within it. The app draws several years worth of data from a view in our Microsoft SQL Server. While each sheet requires the data from the same view, many of them have unique date range requirements. Some example date ranges I need include:
Since these sheets are all a part of the same app, it looks like I cannot use the load editor to get the date ranges I need. This leads me to believe that a set analysis is what I need. Reading the documentation for set analysis, it appears that it works only on a single field. If I have 10 fields I need to display in a report, would I need to do a set analysis on each field? Is there any way to do a set a date range for all fields in a given table?
If by fields you are referring measure columns, then yup you would need to add the set analysis into the expression for each measure.
If by fields you are referring measure columns, then yup you would need to add the set analysis into the expression for each measure.
I had assumed that there would be a way to do it for a sheet or table and wanted to verify before I dove in. Thank you for your reply!