indepriest
New Member
- Joined
- Apr 4, 2014
- Messages
- 1
I would like to ask some MDX expert to help me with the following:
1) My calculated measure in excel looks like this and returns sales revenue in a given day:
SUM([Measures].[Sales],[Time span base].[Time span base].[Days].&[41177])
2) My second calculated measure in excel looks like this and returns the current date in the serial number format:
Datevalue(Format(Now()-1,"dd.MM.yyyy"))
3) In my third calculated measure in excel I was hoping to combine the two to get my yesterday's sales revenue, but my syntax isn't working:
SUM([Measures].[Sales],[Time span base].[Time span base].[Days].&["+Datevalue(Format(Now()-1,"dd.MM.yyyy"))+"])
Can you please let me know what I'm doing wrong? I would really appreciate any help with this.
1) My calculated measure in excel looks like this and returns sales revenue in a given day:
SUM([Measures].[Sales],[Time span base].[Time span base].[Days].&[41177])
2) My second calculated measure in excel looks like this and returns the current date in the serial number format:
Datevalue(Format(Now()-1,"dd.MM.yyyy"))
3) In my third calculated measure in excel I was hoping to combine the two to get my yesterday's sales revenue, but my syntax isn't working:
SUM([Measures].[Sales],[Time span base].[Time span base].[Days].&["+Datevalue(Format(Now()-1,"dd.MM.yyyy"))+"])
Can you please let me know what I'm doing wrong? I would really appreciate any help with this.
