Looks like DelimitedSplit8K and a "conversion table" would do the job.

the DelimitedSplit8K would split out the string into individual characters, and then you could join that to the conversion table

(OriginalChar...

Sounds like you have the wrong column in your cube. You have to do the date math on a date column, not a text column. If you fix that,...

How do you do distinct in DAX against the column from the 'one' side, so that it deamplifies what is happening due to the join on the 'many' side?

DISTINCTCOUNT(RELATEDTABLE('TableName')) ?

http://www.sqlservercentral.com/blogs/juggling_with_sql/2011/12/26/dynamic-sorting-in-ssrs/

http://blog.stevienova.com/2012/04/27/dynamic-sorting-using-parameters-in-ssrs/

http://stackoverflow.com/questions/9381726/sort-table-by-parameter-reporting-services-2008

Welcome to SSC.

Since you're new, I'll go easy on you. =)

Thanks for the data, but it's not in a format we can use. If you could provide some CREATE TABLE...

Sounds like you need a Calendar table. Then you can link that to your data table and then group by the Calendar columns. There's a handy Calendar table...

Sounds like you can get the answer by using a cross join and then an EXCEPT or an outer join... but one question first...

Do your tables have primary (unique) keys?...

If you want rows to now show...

Can't you just use Interactive Sorting? (I am pretty sure it's in SSRS 2008, but I haven't used 2008 in a long time, esp. R1)

Right-click on column header row (with...

If you can, buy a copy of SQL Server Developer. It costs about $60 US, which is an absolute steal. While there is a cap on the size of...

I would start by reading Kendra Little's article, which is here[/url].

You might use the WITH RECOMPILE hint to force the generation of a new execution plan, but read her article...

"I have a model with two fact tables. There's a one to many relationship between them."

Begging your pardon, but shouldn't the two fact tables just share common dimensions? I don't...

So what was your question?

From the looks of it, you have a typo... or several. You can use joins, but your SQL has some typos.

customers <> custimers

orders <> order

SELECT...

Apologies if I'm repeating myself. Here's one way of exploring what your best options are...

Since your target users are already Excel folks, either PowerPivot or PowerBI sounds like the...

... that way I can tell my boss that second monitor really is required!