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.
