Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
I am currently using the below expression to calculate YTD sales.
Sum({<FY_Year={2021},Fy_Wk={'1','2','3','4','5','6','7','8','9','10','11','12','13','14','15','16','17','18'}>}[Sales_Value])
Is there a shorthand approach to just sum Weeks 1 - 18, rather than writing each week individually such as 'Week 1', 'Week 2' etc. ?
I use this approach for not only YTD sales but a number of other expressions.
Thanks in advance!
Thanks Vegar, adjustment worked perfectly!