Forum Discussion
Sorting by total spend, getting cumulative % , and categorizing
Hello everyone, I hope all is well. Kindly need your help with the function below. Able to do it in Excel but not on PBI. This is the easy option to do it, the more complex one is to th...
Hi claudedubois
1. Are you looking to do this in power query or in DAX?
2. Can you share the sample data on the left above in text-tabular format instead of in a screen cap, so that it can be copied?
|
|
Please accept the solution when done and consider giving a thumbs up if posts are helpful. Contact me privately for support with any larger-scale BI needs, tutoring, etc. |
Hey, thanks a lot for checking my post, the data is below in tabular form.
Regarding DAX vs. power query, I'm not sure as I don't know if you can actually do it in both. I think in DAX it's almost impossible correct? Either method that works is fine.
