Forum Discussion
Multiply previous month by a compounded return measure
Hello community, Hope you are well. I am hoping someone can help me - I've scoured the internet to try and find a solution on this. I am trying to achieve the following in Power BI using ...
Hello amitchandak - thank you for the help - appreciate it.
The measure you provided does it for the next month only from the previous month in the Return column - the rest of the year equals the compounded return only - see below
amitchandak
Super User
Super UserAnonymous .Can you share sample data and sample output in table format? Or a sample pbix after removing sensitive data.
amitchandak thank you, i've pasted a link below:
https://drive.google.com/drive/folders/1T5EN-Vbmq5oJgGNdU9DBpbmjwDQQrRh3?usp=sharing
The first sheet in the Excel is the data imported to Power BI. The second sheet is what I am trying to achieve in Power BI.
Let me know if you have issues accessing the files.