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...

My guess is that you would have to use a stored procedure and check for existence before doing your insert(s). The problem is that you can't declare something has...

If you're importing from an .MDB (as opposed to an .ACCDB) file, I'd use the JET 4.0 drivers.

What version of SSRS were the failing reports built with?

Loop through Excel Files and Tables by Using a Foreach Loop Container

I'm just slow...

This worked:

HighestGrades = SUMMARIZE('Toxicity'

...

Can't really answer all your questions...

If you have something other than a free version of SQL Server, use SSIS to clean your data prior to writing it to your database.

Tools......

I'm okay at SQL, so I sort think of DAX in terms of SQL, which is clearly not the best way to do it. Might have to re-read all...