Supplies are limited. Contact info@espc.tech right away to save your spot before the conference sells out.
Get your discountScore big with last-minute savings on the final tickets to FabCon Vienna. Secure your discount
I have a dax calculation that errors out. i am very new to dax and trying to figure out what i did wrong.
Total_Sales_Prior_Year =
VAR InventoryTypeFilter =
FILTER (
'SALES ORDER, SHIPMENT, & INVOICE DATA',
[INVENTORY TYPE] = "GROWER"
)
VAR SalesOrderStatusFilter =
FILTER (
'SALES ORDER STATUSES LUT',
[SALES ORDER STATUS] = "SHIPPED"
)
VAR StyleFilter =
FILTER (
'STYLE LUT',
[INCLUDE/EXCLUDE] = "INCLUDE"
)
VAR GradeFilter =
FILTER (
'GRADE LUT',
[INCLUDE/EXCLUDE] = "INCLUDE"
)
VAR v_Current_Year = MAX ( 'DATE LUT'[CROP YEAR] )
RETURN
CALCULATE(
SUM( 'SALES ORDER, SHIPMENT, & INVOICE DATA'[EQUIVALENT QUANTITY]),
InventoryTypeFilter,
SalesOrderStatusFilter,
StyleFilter,
GradeFilter,
'Table'[Year Number] = v_Current_Year - 1
)
Not sure where to start with the troubleshooting
In Tabular editor i get Error Syntax error near Total_Sales_Prior_Year. Expected EOF / DEFINE / EVALUATE
In Dax Studios
User | Count |
---|---|
12 | |
12 | |
8 | |
8 | |
6 |
User | Count |
---|---|
27 | |
19 | |
14 | |
11 | |
7 |