Forum Discussion
Cross Table to Flat Table
Greetings, Tables: "rebates" "sales" Calculated columns: Rebate 2016B = IF(sales[year]=2016, sales[Rebatable]*related('2016 Rebate'[Percent%])) Adj 2016 Rebate = CALCULATE(SUMX(FILT...
Thank you for the response, however using MAX did not change the results. Per your advice here is link to a shared pbix file in DropBox.
https://www.dropbox.com/sh/9zjq96vphko356t/AABLGEqzmlleozv2g6yfIS9qa?dl=0
I very much appreciate comments and suggestions from the Power BI Community.
Regards.
Eric_Zhang
Microsoft Employee
Microsoft Employee
Anonymous wrote:
Thank you for the response, however using MAX did not change the results. Per your advice here is link to a shared pbix file in DropBox.
https://www.dropbox.com/sh/9zjq96vphko356t/AABLGEqzmlleozv2g6yfIS9qa?dl=0
I very much appreciate comments and suggestions from the Power BI Community.
Regards.
Anonymous
Thanks for sharing the pbix file. Try
Total2016RebateM = CALCULATE(MAX(sales[Adj 2016 Rebate])+SUM(sales[Rebate 2016B])/100)