DAX Result in Excel Cell

[gavs73]

Hi

Hopefully a quick question, in my PowerPivot I have a DAX calculation:

S12015:=CALCULATE([Salesx],Data[Month]="22016",Data[PRODUCT]="ixP")

Is it possible to reference the result directly in an Excel cell ?, e.g. can I say Cell A1 =[S12015] If so, what is the correct syntax ?

Thanks for your help.

Gav

 

[Matt Allington]

Place the measure in a pivot table. On the PowerPivot menu (varies by version), find the OLAP tools menu option, then select convert to formulas. You should then have what you want - and also will see the syntax. They are easy to write - just follow the pattern and the intellisense will help you.

 

[gavs73]

Thanks Matt