Earn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.
I am analyzing M&A data. For most companies in my table, I have fees incurred by the Acquirers and Targets, from the year before the deal to two years after the deal. I would like to calculate the fees the Acquirer incurred in year 2 post-deal, and as a percent of the combined Acquirer + Target fees the year before the deal. While the math is simple, i need to create a measure that will assess each row in my table and only run this calculation where data is available for all entities (Acquirer and Target) and for all the years involved. I created measures of "Total Fees" for each entity and for each year. Below is the calculated measure i used to run the needed calculation row by row, but I don't think it is corrrect. Can anyone help?
2yrs post/pre = CALCULATE( if ([Acquirer Fees PreDeal]>0 && [Target Fees PreDeal]>0 && [Survivor Fees 2yrs Post Deal]>0, DIVIDE([Survivor Fees 2yrs Post Deal], sumx(DealDATA, [Acquirer Fees PreDeal]+[Target Fees PreDeal]), 0)))
hi,@sunb1
You may try to use calculate to change the context when use sumx function ,It needs data sample to Concrete analysis,
So could you please share your pbix or the data sample and expected output.
You can upload it to OneDrive or Dropbox and post the link here. Do mask sensitive data before uploading.
Best Regards,
Lin