Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
7 years ago

DAX Calculation

Hi,   Issue: The date range has to be flexible. (Slider)  Parameter 1 = Amount Invested Parameter 2 = Amount withdrawn at the end of each year   Say I invest $1,000,000 (Parameter 1) in a fund...
Need Help
Anonymous's avatar
Anonymous
Not applicable
7 years ago

HI Anonymous ,

Your formula not works on my side(it says syntax error), can you please fix it?

BTW, I think you need to add a variable summary table to calculate each row result, then you can use sumx function to get cumulative based on that table.

Regards,

Xiaoxin Sheng

  • Anonymous's avatar
    Anonymous
    Not applicable
    7 years ago

    Hi Anonymous ,

     

    The code works on my side.

     

    Any ideas on how do I script the requirement of withdrawing money every year?

     

    Thanks

    • Anonymous's avatar
      Anonymous
      Not applicable
      7 years ago

      Hi Anonymous ,

      Can you please share a pbix file for test?

      Regards,

      Xiaoxin Sheng