Productx with measure
Hi Dear DAX Experts, I know the almost excactly the same question has been asked before by sgupta22 but the solution was presented in the BI File and the file is no longer available. So let me ask for help for the following problem: I want to compound monthly growth rates. The growth rates are the result of a Measure: So far so good, but now I want to compound theses growth rates by creating an Index showing the cumulative growth and I do not know how to do it. If the rates were in a column I could use productx. But the rates are in a measure. In Excel what I need would be this: Is there a way to do this? Thanks in advance. Markus
ProductX returning unexpected results when iterating over date.
I have created two PBIX file, everything is the same, except for the date dimention is useding a string, 1-8, instead of a date. With that being the only change, I am getting getting different results on productx measure Link to the two PBIX Files https://docs.mobius.kiwi/f/4526097a6d2e49cdbd5c/ https://docs.mobius.kiwi/f/3066c5de5db04c9fbd79/ The measure I am using is tmpmreturnsproduct = var mindateapplied = MINX(ALLSELECTED('DimDate'), 'DimDate'[Date]) return 100 * CALCULATE(PRODUCTX('DimDate',1+[tmpmReturns]),filter(all('DimDate'),'DimDate'[Date]<=max('DimDate'[Date]) && 'DimDate'[Date] >= mindateapplied)) I am completly stumpt has to why I would get different results with iterating over a date, or have had any luck working out the correct Dax for the Date formated version. Doing Some more testing. As soon as I change the Datatype in the Date Table from Whole Number to Date, the 'calculation error' occuers...
