Rob Collie (PowerPivotPro.com) points out which versions contain the PowerPivot features on his blog here[/url].

Thanks for confusing everyone again, Microsoft. </snark>

Yeah, I would hope so. The "documentation" was absolutely hilarious - I photocopied that page and hung it on my wall. I think I wrote "JOB SECURITY" across the...

USE tempdb;

GO

CREATE TABLE Customer (

CustomerID INT IDENTITY,

FirstName VARCHAR(15) NOT NULL,

LastName VARCHAR(20) NOT NULL

CONSTRAINT pkCustomer PRIMARY KEY (CustomerID) );

CREATE TABLE CustSite (

SiteID INT IDENTITY(100,1),

SiteName VARCHAR(10) UNIQUE NOT NULL,

RelatedCustomerID INT NOT NULL

CONSTRAINT...

Where are you getting the frequency information from? Care to share that part?

LOL...

<insert TERRIBLE advice here> ... and don't forget to ascribe to someone who actually knows what he's talking about.

Sorry, couldn't resist!

The question reminded me of some "documentation" of a database...

This is a great discussion on triggers.

Here's the MS page on creating triggers. https://msdn.microsoft.com/en-us/library/ms189799.aspx

Edit - just looked around here and Dwain Camps wrote a great article on triggers[/url]. Definitely worth...

Welcome to SSC. Thanks for the CREATE TABLE and INSERT scripts... they're easier to use if you post them this way, though:

CREATE TABLE Employee(

EmployeeID INT PRIMARY KEY,

EmployeeName VARCHAR(20) NOT...

GoogleFu must be broken... There's a bunch of documentation on the MS website... <putting on my pointy hat D-U-N-C...>

http://social.technet.microsoft.com/wiki/contents/articles/677.power-bi-data-analysis-expressions-dax-language.aspx

JOIN()?

multiple values where? In a multi-select parameter? In your report somewhere?

(Makes me think this place needs a "canned response macro"... )

😀

Got table definitions? Sample data? (Create table and insert scripts)... can be completely fake, just representative.

One thing I would definitely suggest is collecting a list of common questions that you're going to ask of your database, and test your design by trying to answer the...

No wonder I'm so good at SSRS...

"I'll take cryptic UI for 1000!"

You might find this article helpful:

Unpivot a Table Using Cross Apply[/url]

I'm pretty sure I asked a question like this a while back, and the trick is to use dynamic SQL...