I tried installing Access Runtime x86, as advised, but got error: 'We can't install the 32-bit version of Office because we found the following 64-bit programs on your PC: ...

attached screenshot of services running, and it appears SQL Server <instance> is already running. BTW, am able to use my instance to connect to remote servers/instances, only not my...

ok, one step at a time. How to check "the SQL Server service is running". when I search for SQL Server Configuration manager it only returns SQL Server...

I failed to mention how I'd checked etc.

Usually all versions are listed in drop down, so it's inconsistent for them to only list 2012, and lack of deprecated doesn't...

thanks for checking.

Hi Jeff, Oh, I did mention synonyms to them.

The reason (verbatim) they gave:

"Using a linked server you may get into a double hop situation which we would not be able...

Deployment folks do not want me to use a sproc because it involves a linked server. I must supply the full query in the SSIS package and get around...

Thanks for showing there's an alternative. I've got 9+ columns and will try to modify away from unpivot function. Have 20,000 rows. Suppose using CROSS APPLY will as...

thanks for the quick help. Never would have thought like this.

The issue I had was more complex. Not only two fact tables with different levels of hierarchy which I reconciled with a composite key, in the manner suggested in one...

Because I was frazzled I thought it was understood that there is a dimension between them. Tabular SSAS wouldn't allow me to create a relationship between them even if I...

Thanks Brian.

BTW, I attended a PowerPivotPro users meeting in Redmond yesterday and regarding ISFILTERED syntax for applying logic at different levels of hierarchy, I was advised as best practice...

Thank you both for helping to explain some finickiness with SWITCH.

I needed a switch statement that could analyze a whole column for existence of "MCS T&M" and "Subcon T&M"...

ja, it is great Brian!

against forum etiquette...

Can you give me one more help?

Trying to embed a CASE statement inside the formula, but can't get even the simple case working as...

Hey, I think that's working, Brian.

PlannedRev:=if(ISFILTERED(Engagements[EngagementName]), SUM([SubconFFLTDRevenue]), IF(ISFILTERED('Project Types'[ProjectType]), SUM([SubconTnMLTDRevenue]),100))