Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

Register Log in
  • Congratulations IamaSherpa on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

MDX

Status
Not open for further replies.
NotSQL

NotSQL

Technical User
May 17, 2005
205
GB
I trying construct the first day of the year with no success.

I using the following syntax

'January 1,' + vba!Year(vba!dateadd("yyyy", -6, vba![date]()))

Can anyone tell me what I’m doing wrong? Also is there an easy way to work out YTD values without using the Business Intelligence wizard. What Id like to do is really create it as a separate member

Thanks
 
Status
Not open for further replies.

Similar threads

burakcan
  • Locked
  • Question
How to rounding up to next integer value In MDX
Replies
0
Views
321
burakcan
burakcan
Recce
  • Locked
  • Question
Automating MDX
Replies
0
Views
129
Recce
Recce
Rolaper
  • Locked
  • Question
MDX Calc measure to accomdate Smi-Additive and delta SCD at the same time?
Replies
0
Views
173
Rolaper
Rolaper
eo
  • Locked
  • Question
Aggregation type - NONE; but setting aggregation through MDX - how to?
Replies
1
Views
181
Shab
Shab
petersJazz
  • Locked
  • Question
MDX Filter or Except
Replies
0
Views
134
petersJazz
petersJazz

Part and Inventory Search

Sponsor

Back
Top