我在PowerBI中有一个DAX度量,我想在Excel中重新创建,就像在Excel中使用公式一样
这是DAX和支持DAX
GrossProfit Amazon Estimated Pending = CALCULATE([GrossProfit Amazon Orders Estimated] , FILTER(Amazon_Pending_Orders , Amazon_Pending_Orders[order_status] = "Pending"))
GrossProfit Amazon Orders Estimated = [Pending Revenue USD] * [Average GrossProfit Margin]
Pending Revenue USD = SUMX(Amazon_Pending_Orders , Amazon_Pending_Orders[ItemPriceUsd])
Average GrossProfit Margin = AVERAGEX(Amazon_Pending_Orders , Amazon_Pending_Orders[GrossprofitMargin])
对平均值的工作方式感到非常困惑。。。。
编辑:
该表包括Prod_Category、ItemPriceUsd、GrossprofitMargin和order_status
