Siraj.Samsudeen
New Member
- Joined
- Dec 4, 2012
- Messages
- 23
I am working on a project to calculate IRR dynamically using MDX to invoke the Excel IRR function as outlined in this excellent article by Javier Guillen. The MDX query I have written is working for some cases, but is behaving strangely in other cases. I need to debug the query.
I tried running the MDX query in DAX studio. DAX studio is definitely a big help, but it does not allow me to find out which rows are being passed to the Excel IRR function. Is there any method of debugging available that allows me to find out which records are being passed to the Excel engine?
I tried running the MDX query in DAX studio. DAX studio is definitely a big help, but it does not allow me to find out which rows are being passed to the Excel IRR function. Is there any method of debugging available that allows me to find out which records are being passed to the Excel engine?
