Windows Dev Center
No announcements

### MDX Calculation on a Measure for different dates

Is there a good site with MDX samples?
| 5 Replies | 4741 Views | Created by amir tohidi - Thursday, November 11, 2010 2:18 PM | Last reply by amir tohidi - Friday, November 12, 2010 11:51 AM

### MDX - Calculate measure in date buckets

Simplistic answer if its only one query..
| 7 Replies | 1956 Views | Created by Koen Verbeeck - Monday, August 1, 2016 10:04 AM | Last reply by Koen Verbeeck - Wednesday, August 3, 2016 9:01 AM

### Aggregate MDX calculated measure

The base for the calculation is also a calculated measure, which depends on other calculated measures ...
| 6 Replies | 1117 Views | Created by renezmar - Tuesday, January 20, 2015 2:12 PM | Last reply by yger - Tuesday, January 20, 2015 3:11 PM

### MDX using Two IF condition in Same Calculated Measures

Basically you have 2 possibilities: 1) Create a physical measure (can be bound to any measure field) and provide a scoped cell ...
| 2 Replies | 5780 Views | Created by MS308 - Wednesday, July 25, 2012 4:15 PM | Last reply by Pavel Pawlowski - Thursday, July 26, 2012 9:07 AM

### mdx to calculated measure

[Date],[Measures].
| 3 Replies | 4365 Views | Created by RahulKiwi - Wednesday, June 23, 2010 5:20 AM | Last reply by Scott.X.Lu - Thursday, June 24, 2010 1:17 AM

### Calculate the measure in mdx code

&[2012-10] ,[Measures].
| 1 Replies | 2925 Views | Created by BandSr - Friday, March 23, 2012 9:44 AM | Last reply by Suhas Kudekar - Friday, March 23, 2012 9:54 AM

### MDX - Calculated measure over date dimension

As I said initially, I am trying to come up with the MDX that will populate the exprression pane in the "New Calculated Member" of a cube.
| 7 Replies | 6167 Views | Created by JeffCAS - Saturday, November 27, 2010 1:46 PM | Last reply by Deepak Puri - Monday, November 29, 2010 8:21 PM

### SSRS Report MDX DataSet: Getting Calculated Measures' Names and their values

Please refer following MDX query SELECT { [Measures].
| 2 Replies | 4230 Views | Created by Joss83 - Thursday, January 5, 2012 12:35 PM | Last reply by Sandip Shinde - Thursday, January 5, 2012 1:07 PM

### Calculated measure problem in mdx

darin try out this MDX SELECT [Measures].
| 5 Replies | 5842 Views | Created by darim - Wednesday, May 5, 2010 3:22 PM | Last reply by Avinob Roy - Wednesday, May 5, 2010 8:54 PM

### Changing MDX calculated measure in calender year

I have successfully calculated '[max used previous months value]'¨using below mentioned MDX.
| 6 Replies | 995 Views | Created by MahAdv - Thursday, December 7, 2017 10:47 AM | Last reply by MahAdv - Friday, January 19, 2018 8:33 AM

### MDX Calculated Measure.

I have quite a lot and creating calculated fields for every scenario would be a bit too cumbersome.
| 5 Replies | 1140 Views | Created by PentAgraMm - Tuesday, March 21, 2017 5:03 AM | Last reply by PentAgraMm - Wednesday, March 22, 2017 10:35 PM

### Mdx to get the Expression of a calculated Measure

Just click on your calculated measure i.e.
| 7 Replies | 2961 Views | Created by Anandh_SG - Tuesday, April 3, 2012 4:20 AM | Last reply by Darren Gosbell - Tuesday, April 3, 2012 6:42 AM

### Dynamic Calculated measure in MDX

You can't evaluate a member name as an expression in MDX.
| 2 Replies | 966 Views | Created by BharathRS - Friday, May 8, 2015 4:30 PM | Last reply by Darren Gosbell - Monday, May 11, 2015 12:00 PM

### MDX - EXCEPT in Calculated Measure

&[11] is specific group of material which need to be excluded from calculations if 5 of 6 categories are shown.
| 3 Replies | 19112 Views | Created by JesseO - Friday, October 29, 2010 6:56 PM | Last reply by Elvar - Saturday, March 12, 2011 9:40 PM

### Calculated Measure Question in MDX

Hi Victor, You can use the IIF function: WITH MEMBER [Measures].
| 1 Replies | 4391 Views | Created by Victor Xiao - Tuesday, May 25, 2010 7:35 PM | Last reply by Boyan Penev - Wednesday, May 26, 2010 1:04 AM

### MDX Sytax for SSAS Calculated Measure using "OR"

Set up a big CASE statement in your MDX Expression window: CREATE MEMBER CURRENTCUBE.
| 3 Replies | 2505 Views | Created by kayluhh - Tuesday, August 7, 2012 7:37 PM | Last reply by Todd C - Tuesday, August 7, 2012 8:21 PM

### MDX equivalent of DAX YTD measure

but without the MDX for the actual measure incorporating the periods to date, i cannot make it work because i'm a total MDX noob.
| 8 Replies | 1240 Views | Created by PentAgraMm - Monday, January 15, 2018 1:27 AM | Last reply by RichardLees - Tuesday, January 23, 2018 5:14 AM

### Create Calculated Measure with MDX and Where Clause

The Exchange Rate measure can be put into the MemberExpression of Sales measure so that you don't need to create a calculated measure.
| 1 Replies | 879 Views | Created by ColacoCT - Saturday, June 11, 2016 2:13 PM | Last reply by Simon_Hou - Monday, June 13, 2016 8:43 AM