Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi,
I have written the following code which works fine
sum({<DateNew={"=$(=vL3MMax)"}>}[Volume(HL)]) gives 123
But as soon as I want the sum for the datenew greater than vL3MMax then It gives 0.
vL3MMax=AddYears(MAX(DateNew),-1) gives 0
sum({<DateNew={">=$(=vL3MMax)"}>}[Volume(HL)])
what is that I am doing wrong.
Regards
Rahul
May be this?
sum({<DateNew={">=$(=$(vL3MMax))"}>}[Volume(HL)])
The variable definition stayed the same between the 2 tests? the only thing that changed was the addition of >=? or did you change the variable definition also?
The variable definition remained the same Sunny.
Regards,
Rahul
Could you share a representative sample qvw to investigate?