Syntax errore

[#1]

Could u please correct syntax errore in set analysis

[tamilarasu · Accepted solution]

Hi,

Correct syntax should be,

=sum({$<[Year]={"$(=max(Year))"}>}[Order Quantity])

=sum({$<[Year]={"$(=max(Year)-1)"}>}[Order Quantity])

Check the attachment and let me know.

[sunny_talwar]

Didn't check what Tamil have (may be I am repeating), but just thought I will also share my solution

=Sum({$<[Year]={'$(=max(Year))'}>}[Order Quantity])

=Sum({$<[Year]={'$(=max(Year)-1)'}>}[Order Quantity])