Nice one thanks.

Am I confusing expressions with Queries here ?

Quote from BOL

"DAX expressions cannot be used where an MDX expression is required and vice versa."

Great question, took me back to the library

Never mind folks.. resolved. It was not the service account that sql runs under that he used rather an application specific - Vcenter - which he is the app owner...

Nice question, new tool for me.

Thanks

Thanks Jeff, appreciate the advice.

Interesting QotD thanks.

Nice easy on thanks.

Hashbrowns, HASHBYTES, Hashish its all the same 😛

Nice question and explanation. Thanks

Thanks for the heads up Jeff, how would you tackle it then ?

Nice n easy thanks.

Nice way to end the week, thanks

Had to do some digging for this one - nice question thanks.

Refined and resolved !!!

Thanks for all your input.

This is the working query.

SELECT

YEAR(CAST (a.ENDDATE AS DATETIME)),

MONTH(CAST (a.ENDDATE AS DATETIME)),

(

SELECT

...