Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi all,
I can't seem to get an expression working. I have a variable
vWeekIndex
which has the following definition...
=[Current Week Index]
which just returns the week index of a selected date.
I am trying to write an expression to reference this variable but add 1 also. so..
Sum({<[Current Week Index]={'$(vWeekIndex)+1'}>}[Room Revenue])
I have tried different variations but just can't seem to get it to work.
Any ideas?
It works for me
sum({$<[Current Week Index]={$(=vWeekIndex+1)},Date>}[Room Revenue])
You need to clear selection of the Date field
Try like
Sum({<[Current Week Index] = {"$(vWeekIndex)+1"}>}[Room Revenue])
Or you can try
Sum({<[Current Week Index] = {'$(vWeekIndex+1)'}>}[Room Revenue])
Check This
Sum({<[Current Week Index]={$(=$(vWeekIndex)+1)}>}[Room Revenue])
Check Also this
Sum({<[Current Week Index] = {$(vWeekIndex)+1)}>}[Room Revenue])
Use this
vWeekIndex = [Current Week Index]+1
Exp:
=Sum({<[Current Week Index] = {'$(vWeekIndex)'}>}[Room Revenue])
Thanks all, but i can't get any of them to work.
I have attached a sample.
thanks Ravi,. I have already tried this option (which works) but i would prefer to use the +1 in the expression as i have to do 30+ expressions using +1, +2, +3 etc. i don't want to use 30+ variables
It works for me
sum({$<[Current Week Index]={$(=vWeekIndex+1)},Date>}[Room Revenue])
You need to clear selection of the Date field
Hi,
Try like this
vWeekIndex = Max([Current Week Index])
Expression = sum({<[Current Week Index]={$(=vWeekIndex+1)}>}[Room Revenue])
Regards,
Jagan.