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

I would design the tables in SQL Server and then maybe use Visio to document the relationships... and draw the pictures, but I'm not sure MS left that in the...

About the best you can do is once you add one field from your dataset to the tablix/matrix, then you can choose the other fields by clicking on the next...

Or you could install Reporting Services and do the reporting there... Kind of depends what kind of reporting you're doing. One thing that Access doesn't do well is crosstabs/matrix...

do it in your WHERE clause.

WHERE MyTable.MyDate>DATEADD(yyyy,-1,GETDATE())