Dax prior year calculion

jeannier2022 — Fri, 10 Nov 2023 20:49:00 GMT

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

Re: Dax prior year calculion

FreemanZ — Fri, 10 Nov 2023 20:53:35 GMT

hi jeannier2022 ,

what error do you get?

Re: Dax prior year calculion

jeannier2022 — Fri, 10 Nov 2023 21:00:33 GMT

In Dax Studios

Re: Dax prior year calculion

jeannier2022 — Fri, 10 Nov 2023 21:06:24 GMT

In Tabular editor i get Error Syntax error near Total_Sales_Prior_Year. Expected EOF / DEFINE / EVALUATE

topic Re: Dax prior year calculion in DAX Commands and Tips

Dax prior year calculion

Re: Dax prior year calculion

Re: Dax prior year calculion

Re: Dax prior year calculion