topic Re: Establishing a MarginBridgeAnalyser in DAX Commands and Tips

Establishing a MarginBridgeAnalyser

HenrikStrand — Wed, 30 Aug 2023 07:45:48 GMT

I am developing a margin bridge analyser, as I have done this succesfully in excel. I have several measures that I use like the price variance, but when it comes to the price efffect which is basically the sumproduct (as I would use in excel) of column quantity_baseperiod and price variance (defined in measure as AveragePrice Analysis Period - AveragePrice Base Period ....per item). I ahve researched and the proposal is to use sumx function in dax but this is not very happy about using measures in the calculation...

Re: Establishing a MarginBridgeAnalyser

v-zhangti — Fri, 01 Sep 2023 04:20:28 GMT

Hi, HenrikStrand

Can you provide sample data for testing? Sensitive information can be removed in advance. What kind of expected results do you expect? You can also show it with pictures or Excel. I look forward to your response.

Best Regards,

Community Support Team _Charlotte

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

Re: Establishing a MarginBridgeAnalyser

HenrikStrand — Fri, 01 Sep 2023 08:41:02 GMT

Attached were the pbix file and the excel export w calculations, so you can get an idea of my end game. Appreciate any help!

Re: Establishing a MarginBridgeAnalyser

HenrikStrand — Fri, 01 Sep 2023 10:54:16 GMT

https://www.dropbox.com/scl/fi/eiagq3ks1lqh2hi60qm6v/VPM-TestData.pbix?rlkey=ei0xt0dip0kafvkeche5968gh&dl=0

Re: Establishing a MarginBridgeAnalyser

HenrikStrand — Fri, 01 Sep 2023 10:55:24 GMT

https://www.dropbox.com/scl/fi/sr02kna9119d3wyz7mx3h/Fake-Data.xlsx?rlkey=ow6coelu084bvs48tvrx3zpj3&dl=0

Re: Establishing a MarginBridgeAnalyser

technolog — Sun, 24 Sep 2023 08:00:46 GMT

I hope this message finds you well. I've noticed that this solution remain unresolved. If any of you have managed to find a resolution to the issue, I kindly request that you share your solution for the benefit of the entire community. Alternatively, if you're still facing challenges, please do let us know as well.

Your insights and updates will greatly assist others who might be encountering the same challenge.