route217
asked on
Convert a Power Formula into SQL Syntex
Hi Experts
What is the SQL equivalent of the following DAX (Power BI) Formula
AOV = CALCULATE(SUM(FACTSalesOrderTable[Gross_Order_Value]),ALLEXCEPT(FACTSalesOrderTable,FACTSalesOrderTable[increment_id]))
What is the SQL equivalent of the following DAX (Power BI) Formula
AOV = CALCULATE(SUM(FACTSalesOrderTable[Gross_Order_Value]),ALLEXCEPT(FACTSalesOrderTable,FACTSalesOrderTable[increment_id]))
SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
The docs mention that ALLEXCEPT applies a 'filter' if one exists. That would likely be a CASE statement or a WHERE clause in SQL.
If you can provide some raw data and expected results from the provided data, we can provide the SQL to achieve the results.
Database product and version would help a lot as well.