I can not wrap my head around on how to put the following Excel Formula in Power BI. The goal is to perform this calculation for each row in the Table (#rows =~200).
Solved! Go to Solution.
It is in columns in Power BI, I have tried to pivot the columns but to no avail. This is the data set and expected outcome I am working with: Dataset Link
Thanks that worked. I had tried this solution before but apparently my data model was not set correctly to receive the expected outcome.
Check out new user group experience and if you are a leader please create your group!
Power Platform release plan for the 2021 release wave 2 describes all new features releasing from October 2021 through March 2022.
Click here to read more about the July 2021 Updates
Did you know that you can visit the Power Query Forum in Power BI and now Power Apps