I got this to work...

I started with a dataset with a date column, Consent_Date.

Created a new table and entered this:

NewDateTable = CALENDAR(MINX('PatientSymptoms',[CONSENT_DATE]),MAXX('PatientSymptoms',[CONSENT_DATE]))

... which generated a table of all the...

At the bottom of this page, it says that there are both 32- and 64-bit versions of SSRS.

add a case sensitive collation to your query.

Here[/url]'s a really good example.

here's one I did ...

SELECT *

FROM dbo.Patient

WHERE LastName COLLATE Latin1_General_CS_AS LIKE 'Do%';

so a last name starting with 'DO' would...

Removed the "compare to last week" part...

looks like there's a piece missing:

FROM MyData T1

LEFT JOIN T2

ON DATEADD(yyyy,-1,T1.InvoiceDate) = T2.InvoiceDate

(I think).

I'm pulling week to date sales data (ex. if I were to run it tomorrow it would pull sales totals for Monday and Tuesday of this week). But, I want...

You'll get more help if you post consumable data... like this:

CREATE TABLE LotData (

Lot INT,

TranDate DATETIME,

Qty INT,

UOM CHAR(2),

RunBal INT );

GO

INSERT INTO LotData(Lot, TranDate, Qty, UOM, RunBal)

VALUES (114044, '5/27/2015 3:25 PM',...

Thanks Eirikur! Learned something new today!

Kinda wish you could choose which columns you wanted in the table, but not possible, I don't think. Super handy for when you...

I think that's it. You can't mix 32 and 64bit on the same machine.

What I need to do is a sort based upon the birthdate, lang, and pernum.

Basically the sort for birthdate should meet the following criteria:

a. If a student is under 6...

Jeff,

that's basically what I did. (it's like a mini star schema, and Calendar is just a dimension table). Turns out, I used your calendar table-valued function. =)...

No, I'm using the Calendar table as a Dimension so I can lump sales etc into "bins" -- summarize by Year/Month whatever.

I was using a dataset someone gave me that...

found an explanation for any other intrepid folks that might be trying to create a calendar using PowerQuery... (not sure why one would want to do that, since it's so...

That someone would be me =).

No, I didn't install SSAS. I was just trying to see how much I could do in PowerPivot without using T-SQL. When I...

create a calculated column in your T-SQL to evaluate to 1 or 0 based on your rules, and then sort by that. (Although the sort order in your report will...

I would create a dashboard in Excel or PowerBI Desktop. Doing it in SSRS would be a lot harder.

Drill through in PowerBI Desktop is automatic. No programming or anything...