Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
I have a field 'SET_STATUS_DATE' I will need help with the syntax for <= date comparison for this field using set analysis.
My measure has a field called "Amount" when I added this syntax the results was NULL. not sure why.
Share the expression please.
Is the expression editor showing any messages?
The only message on the expression is Sum(Amount) I removed it and added to syntax you provided it gave me a null value.
Sum({<SET_STATUS_DATE={"<=$(=Max(SET_STATUS_DATE)) )"}>} Amount)
I am assuming above is what you tried.
Like I said before if that doesn't work; Check what the column format is in the data model.
You may need to format it
