I did mine differently. I checked for existence of both class types in the "attends" table...

CREATE TABLE Student(

StudentID INT IDENTITY PRIMARY KEY,

FirstName VARCHAR(10) NOT NULL,

LastName VARCHAR(15) NOT NULL

);

GO

INSERT INTO...

If you have tons of databases to do it on, you could create a cursor to loop through the databases and then run the SQL to enable service broker. ...

You mean something like this? You'd need a Calendar table

SELECT *

FROM Calendar

WHERE TheDate>=GETDATE()-90;

toggle the visibility by making it depend on an expression might be an option.

you can only filter a dataset as a whole, not just a matrix or whatever where you use the dataset. Unless there's something I've been overlooking all this time.

One option might be SSIS to a new database? (then you can clean in between... in the SSIS pipe).

it's a star schema. It's just normalized a different way. One relatively painless way into understanding some of star schemas is Rob Collie's book "DAX Formulas for Power...

Yup, I'm being stupid... figured it out... I had to select the formula for the Measure first!

(still kinda wish PowerBI Desktop acted just a little more like Excel!!!)

You can use an FTP task in SSIS. You might want to look at Brian Knight's book. Knight's Microsoft SQL Server 2012 Integration Services 24-Hour Trainer

It covers the basics...

Steve,

you can add as many datasets to your report as you like... the caveat is that you can only use one dataset at a time in a single tablix/matrix.

If you...

Once you create a dataset, you can convert it to a shared dataset. Shared datasets can be used in multiple reports, because they "belong to" the solution, not the...

https://www.mssqltips.com/sqlservertip/3549/inventory-sql-server-services-version-and-edition/

If you want to learn PowerPivot, get Rob Collie's book. Takes a bit to get your head around, but he's really good at walking you through a lot of stuff....

You could do this in PowerPivot... makes it really easy... You can use PowerBI, which is a free download too... if you can get someone to install it for you....

Instead of using a tablix, use a matrix. then put the date field in the columns part of the matrix and you should be off to the races.