Can anybody tell me why my dax formula is not working?

[cdawidow]

it is coming up as a synthax error for <  any ideas why ? 

[harshnathani]

Hi @cdawidow ,

Answer is provided above.

Also would suggest you use variables and best practice to use measures in variables.

See this video by Jeffrey Wang.

https://www.csgpro.com/blog/2019/04/dax_overview_jeffrey_wang_portland_powerbiug/

47:01 

Regards,

HN

[AntrikshSharma]

Missing closing parenthesis after DESC. Use DAX Formatter to easily figure out where the error is.

https://www.daxformatter.com/