Hi All, have below expression:
if(aggr( max(date(if(Date1<=Date2,Date3))), Name, ID, Region)=[Date3], [Final Sales])
I would like to know whether there is any other possible alternate way to write the if part of above expression:
I have tried below way :
if(aggr(max(date(Aggr(only({<Date1={"<=$(=Date2)"}>}[Date3]), [Date3]))),
Name,ID,Region)=Date3,SalesAmount)
My expectation is to avoid selection of Continent field on the result of above 2 expressions, but even after bypassing the field in set analysis, the selection of Continent is still getting applied to the result of 2 expressions.
The selection can be avoided by using only function on the top of above 2 expressions , but in that case the final result., i.e., SalesAmount is getting changed., and if I remove Only function then I am getting proper salesamount but then selection of Continent field is getting applied.
Can you plz help
AATISH
