Forum Discussion
che1569250
5 years agoRegular Visitor
Is it possible for this R loop to be converted to DAX?
Hi all, I have an R loop that I'm running at Power Query level in Power BI. I'd like to be able to move this into DAX so I can use a parameter in my report, that the report user can add in themselves...
v-diye-msft
5 years agoCommunity Support
Hi che1569250
Sorry I'm not quite understand the calculation logic, could you plz consider providing your dummy pbix that would be helpful for us to investigate it further.
You can upload it to the onedrive for business and share the link here. please don't forget to disclose the expected results and remove the confidential info.
che1569250
5 years agoRegular Visitor
Hi, this is a link to a Power BI file with a table of how the data starts and another table with how I want the data to look at the end. I need this to be done via DAX as I want to be able to enter "outstanding balance" as a parameter so it can change and update.
Also, this a link to a file to show how I can do it in Excel.