Set Analysis

[risabhroy_03]

I am using the below expression 

Sum({<[Source]={'Stage 2'},[As on Date]={[Final ASDT]}>}[Weight])

But my sum is coming as 0.

I guess there is some error while equating [As on Date]={[Final ASDT]}

For both the date fields I have used floor num and both are in the same format.

[AshutoshBhumkar]

Hello,

You will need to use aggregation function in the set

E.g 

Sum({<[Source]={'Stage 2'},[As on Date]={"$(=Max([Final ASDT]))"}>}[Weight])

What are you expecting with  [As on Date]={[Final ASDT]} ??

[MayilVahanan · Accepted solution]

Hi

If you want to include the possible values in "Final ASDT", then try like below

Sum({<[Source]={'Stage 2'},[As on Date]=p([Final ASDT])>}[Weight])

[risabhroy_03]

As of now my [Final ASDT] has only a single date present,

but next year one more date will be added to it, so will it automatically consider both the values of [Final ASDT]?

[MayilVahanan]

Yes, it will consider both the values.