topic Re: Trying to Combine Actuals and Forecast using DAX- keep getting Syntax error in DAX Commands and Tips

Trying to Combine Actuals and Forecast using DAX- keep getting Syntax error

atowriss1 — Fri, 30 Sep 2022 00:48:32 GMT

Hi,

I was following a tutorial om combining Actuals + Forecast so I could show on 1 line by following a tutorial. I keep getting a Syntax Error- I cannot figure out why. Here is a link to my file if anyone can help: https://1drv.ms/u/s!AtrPn7_C_8_IhB6hTdmEYfSsE8vX?e=jQosxa

Thanks

Re: Trying to Combine Actuals and Forecast using DAX- keep getting Syntax error

tamerj1 — Fri, 30 Sep 2022 02:31:46 GMT

HI atowriss1
Actually there are two syntax errors. The vriable name "Actuals" is the same as the table name "Actuals" which is not allowed. Also the "RETURN" statement was missing. Please refer to attached file.

Re: Trying to Combine Actuals and Forecast using DAX- keep getting Syntax error

atowriss1 — Fri, 30 Sep 2022 02:40:29 GMT

Thanks so much!!