How can I code an mdx statement to return either the number for the current day of the week (ie. 1 - 7), or the name of the current day (Monday, Tuesday, etc.)? day(now()) gets me the actual calendar day
Thank you,
PB
Hopefully, this helps you get where you want to go:
Code Snippet
with member [Measures].[x] as
datepart("w",VBAMDX!Now())
select [x] on 0
from [Adventure Works]
;
B.
No comments:
Post a Comment