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

Maybe this will help?

Displaying Sorted Hierarchies[/url]

FirstDelim and SecondDelim are just (intermediate) Calculated Fields in my SSRS dataset. The result you're interested in is the third one that use FirstDelim and SecondDelim. You could...

I created two fields in my dataset

"TwoFields" is the name of the field containing the raw data

FirstDelim = INSTR(Fields!TwoFields.Value,"=")+1

SecondDelim = =INSTRREV(Fields!TwoFields.Value,"=")

=CDBL(MID(Fields!TwoFields.Value,Fields!FirstDelim.Value,Fields!SecondDelim.Value-Fields!FirstDelim.Value))

If you can, I would probably do as Alan suggested...

DATEADD(qq,DATEDIFF(qq,0,GETDATE())-3,0)

... returns a DATE value.

'2015 01' is a STRING value, not a date. You would have to turn that into a date... maybe split off the year, and add...

This worked with the data you posted:

CDBL(MID(Fields!TwoFields.Value,INSTR(Fields!TwoFields.Value,"=")+1,INSTRREV(Fields!TwoFields.Value,"=") - INSTR(Fields!TwoFields.Value,"=")+1))