Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hello,
I have an expression that works on my KPI but does not work when I make a variable. My objective is to show the sum for the maximum date as a KPI.
=Sum({<[Month-Year]={"$(=Max([Month-Year]]))"}>}VALUE)
How are you defining the variable? Can you show an example?
SET eCurrent =Sum({<Month-Year={"$(=Max(Month-Year))"}>}VALUE);
I believe the $-expansion is taking place at the time you are defining the variable. Try this instead:
Let eCurrent = 'Sum({<Month-Year={"$'&'(=Max(Month-Year))"}>}VALUE)';
This way, the $-expansion will occur when you use the variable in a measure expression $(eCurrent).
No Luck. For the life of me I cannot figure out what the issue is