Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hello Friends,
As I am trying to fine the sum of sales for the maxium year.
I tried the following but it throws a error.
=Sum({<ShipmentYear={'$(=max(ShipmentYear))'>}}[Sales])
Could you please help me..
Regards
Chriss
Just a typo it seems. Try:
=Sum({<ShipmentYear={'$(=max(ShipmentYear))'}>}[Sales])
Just a typo it seems. Try:
=Sum({<ShipmentYear={'$(=max(ShipmentYear))'}>}[Sales])
Hello Gysbert,
Thanks a lot, it works, I tried this for the past 2 hours, came with a good solution.
Reagrds
Chriss