Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
6 years ago
Solved

Dax Help

Hi, I am trying to calculate the below excel formula in Power BI as a calculated column (DAX or MQuery or Python)   Formula: IDA = ((1 + (Current value of PX_LAST/10000)) * Next IDA value)   Sam...
Need Help
  • lbendlin's avatar
    lbendlin
    6 years ago

    Well, never say never.

     

    Behold:

     

    IDA_m = 1+max('Table'[PX_Last])/10000

IDA_p = 
var d=max('Table'[As of Date])
return 10000000*PRODUCTX(filter(all('Table'),'Table'[As of Date]<=d),[IDA_m])
Anonymous's avatar
Anonymous
Not applicable
6 years ago

lbendlin Thank you!! That worked.

lbendlin's avatar
lbendlin
Super User
6 years ago

Thank you for giving me the opportunity to learn about PRODUCTX().