You may need to use SUMMARIZE. Think of it like the DAX equivalent of a summary query in T-SQL... Complete with GROUP BY etc.

Here it is from the MS...

In that case, you would...

I would do this with a (deliberate) cartesian product between Calendar and ParkingSpaces...

SELECT p.ParkingSpace, c.CalendarDate

FROM ParkingSpaces p CROSS JOIN Calendar c

WHERE c.CalendarDate BETWEEN '01-Jan-2016' AND '31-Dec-2016';

then just insert that result...

See if Alan Burstein or Eirikur Eiriksson will bite... might be Monday though.

I have a reasonable idea of what you're trying to do... What are the rules for removing non-numeric characters in the string, though?

What specifically do you mean by "standard" strings?...

Can't you do a simple

INSERT INTO DestinationTable(Col1, Col2, Col3...)

SELECT GrpBy1, GrpBy2, SUM(NumericField)

FROM SrcTable

GROUP BY GrpBy1, GrpBy2;

TinDog,

If you haven't done so already, check out PragmaticWorks.com Brian Knight knows SSAS inside and out. There are a bunch of free tutorials on their website. I think...

Read this article[/url]. Note the warning: "Downgrading to a lower edition cannot be done in place. This tip will describe the steps needed to downgrade."

If you can, install a copy...

Welcome to SSC!

Since you're new and haven't quite figured out how to ask a good question, please help us to help you by reading this article[/url] and following the instructions...

If you create a table of dates for the MWF dates, then you can use ROWNUMBER() to assign a sequential value to each date... then you can find a gap...

If you're using 2012 or later, you can use LAG.

SELECT ID

, FLAG

, LAG(DT, 1) OVER (PARTITION BY ID ORDER BY DT) AS EffectiveDate

, DT AS TermDate

FROM ##Test;

Note that I'm assuming...

I guess if you're forced to do something "clever" then you have to document your code inside the code... not in some "book" somewhere that nobody can find. (Yeah, I've...

What's wrong with the INSERT INTO without all the variables?

INSERT INTO DestTable(col1, col2, col3)

SELECT [DISTINCT]...

a tally or numbers table is perfect for this. Jeff Moden has a great article on it here[/url].

Basically, you join your table that has the quantity you want to...

Maybe he wants to see how painfully slow they are?