an alternate to If statement

aatish12345 — Fri, 15 Nov 2024 21:40:54 GMT

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

topic an alternate to If statement in App Development

an alternate to If statement