Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Could u please correct syntax errore in set analysis
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.
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.
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])