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

happycat,

I was wondering how to do it in DAX without "cheating" (well, if you read Rob Collie's book, he does everything explicitly).

The basic idea of what I wanted was basically...

Did you look at the execution plan for the SQL statement? It should tell you where the problems are.

If you're using scalar functions in there, then that could be a...

there's no information on the structure of your function. What does your function do?

Not sure what you mean by "executing functions from Table column"... The solution to this might...

The sample data doesn't make much sense... how a school could accept more people than applicants is a big weird, but anyway...

CREATE TABLE Applications(

AcadYr INT,

Accepted INT,

Applied INT);

GO

INSERT INTO Applications(AcadYr,Accepted,Applied)

VALUES (2010,100,400),

(2011,200,300),

(2012,300,200),

(2013,400,100);

SELECT...

Got Google?

http://www.techrepublic.com/blog/windows-and-office/send-an-email-with-an-attachment-using-powershell/

took maybe 15 seconds

I think it would be something along the lines of

CALCULATE ( [Total Sales],

DATESBETWEEN(DATEADD("week",-6,Calendar[Date]),Calendar[Date]) )

Super convenient that it's called REPLACE in T-SQL and something entirely different in .NET/SSRS, right?

I ended up with this:

=Replace(UCase(Fields!AcctStatus.Value),"CANCELLED","<span style='color:red;'>Cancelled</span>")

Maybe I'm doing it wrong, but it would be super handy...

Now I'm confused. LIKE is a SQL keyword. AFAIK, you can't use it in SSRS.

If you're trying to color the word "cancelled" red, then you could do something like...

Is the text containing the word "cancelled" static (or there are a limited number of versions of it)?

Might be that I don't know enough about SSRS, but I think you...

Joe,

Do you only want to format the word "cancelled"?

This highlights the whole field:

=IIF(InStr(LCase(Fields!AcctStatus.Value),"cancelled")>0,"Red","Black")

(but it depends on what you attach the formatting to).

Looks like he's trying to pass multiple values into a stored procedure without using a TVF, or something like DelimitedSplit8K().

This worked for me:

USE tempdb;

GO

CREATE TABLE test (testID int identity,

clientID int);

GO

INSERT...

You would execute your stored procedure inside the WHILE loop.

WHILE @CurrDate<@EndDate

BEGIN

EXEC myStoredProc @Param1, @CurrDate;

SET @CurrDate = DATEADD(wk,1,@CurrDate);

END