Don't think you can use UNPIVOT then either. Not sure if this will work, because 2019 doesn't allow a compatibility level to 2005.  Maybe this works?

SELECT AccountID
 ,...

2019.

You can change the compatibility level if you want to, though.

Why not create a Total Sales measure, and then reuse it?

[Total Sales] := SUM(Sales[ExtendedAmount])

[PM Sales] := CALCULATE ( [Sales], DATEADD(DimDate[FullDateAlternateKey],-1,MONTH) )

Then growth is just

[Total...

Go into the Calendar/Dates table, and select the CalendarMonth column. Then in the ribbon, click on "Sort By Column" and select MonthNumber

If you download the AdventureWorks database and the Data Warehouse version, you'll see the difference. They're very different.  I'm sure there are tutorials all over the place, but the purpose...

Grant Fritchey has a bunch of videos on YouTube where he shows you how to do a bunch of database backup & restore things. Definitely worth watching.

Wait wait wait...

you can only reference a CTE immediately following the declaration. Why do you need a CTE for this at all?  What are you trying to accomplish?

Select @localvariable = count(*) from server_cte

SELECT ServerName + ', ' AS 'data()'
FROM ServerList
FOR XML PATH('');

Mike... most of the answer that I found is right here...

DECLARE @g geography;  
 DECLARE @h geography;  
 SET @g = geography::STGeomFromText('POLYGON((-122.358 47.653, -122.348 47.649, -122.348 47.658, -122.358...

That's an awful lot of points for someone who can't even post consumable data. I guess this is required reading then: Forum Etiquette: How to post data/code on a...

Sorry, missed the NVARCHAR. (The answer is in the same article, though!)

That was cheating-level easy... except you need a helper function, Jeff Moden's DelimitedSplit8K function. It's here https://www.sqlservercentral.com/articles/tally-oh-an-improved-sql-8k-“csv-splitter”-function

Here's the SQL:

SELECT x.Item AS Category
 , COUNT(*) AS UseCaseCount
FROM 
(
 SELECT ID
  ,...

INSERT INTO OtherDatabase.Schema.Table (<field list>)

SELECT <field list>

FROM...

Or you could

INSERT INTO db.schema.table (field list)

EXEC storedProcName @param1='x', @param2='y';

The query will eliminate the sets that have already been added. That's what the NOT EXISTS predicate is for.

I guess if you don't like it, you could always write your...