Forum Discussion
Daxmax
Helper I
Helper ICalculate IRR from inception until slicer selection, while other metrics only for that selection
Hello Community, My report needs to display IRR from inception until the year and quarter selected in the slicer, while the same report has other metrics that display only for the year and quarte...
Hi community, i was able to figure out the issue. I had to remove filter context using ALL(), and then use XIRR.
My measure is
measure=
var quarter = SELECTEDVALUE(table[quarter])
return CALCULATE(XIRR(.....), ALL(table[quarter]), table[quarter] <= quarter))
amitchandak
Super User
Super UserDaxmax , are u using xirr of power bi ?
https://docs.microsoft.com/en-us/dax/xirr-function-dax
Can you share sample data and sample output in table format? Or a sample pbix after removing sensitive data.
DaxmaxHelper I
Helper Iamitchandak , yes i'm using XIRR of PowerBI