product function
1 Topic
Can I replicate Product function from excel in DAX?
Trying to get Dax to do a Product array calculation, perhaps there is a better way too. if i have a table with below: Date Spread 6/19/2019 0.007414 6/20/2019 -0.00574 6/21/2019 -0.0049 6/24/2019 0.0095 6/25/2019 0.002036 6/26/2019 -0.01948 6/27/2019 -0.00706 6/28/2019 -0.00784 and I am trying to get to {Product(1 + SpreadColumn row 1:8)}, i should get a result of 97.39165. what function would get me there in Dax? also, if it's able to be filtered by Date ranges as well which would be great! (which would drive the amount of rows the product array considers in the calculation. ) Thanks,Solved1.8KViews0likes5Comments