Forum Discussion
Convert a DAX query for use in Query Editor
I would like to be able to recreate the steps below for use in Query Editor using M, rather than DAX, so it can be recreated and run against numerous queries, before appending them together. The ...
Also, please note that if you are going to calculate the cumulative return over a given period, you can leave the -1 off of the return equation and just do a multiplication of all the daily returns (I think PRODUCTX is the function to use here. See: https://msdn.microsoft.com/en-us/library/dn802544.aspx)