Forum Discussion

admin11's avatar
admin11
Memorable Member
4 years ago

How to convert 2 expression into 1 ?

Hi All

 

Now  i need 2 expression :-

 
_LYTD_OTH_IN =
var _max = date(year(today())-1,month(today()),day(today()))
return
TOTALYTD(('GL'[AMOUNT_OTH_IN]),dateadd('DATE'[Date],-1,year),'DATE'[Date]<=_max)

AMOUNT_OTH_IN =
CALCULATE(
SUM(GL[AMT])*-1,
FILTER(
GL,
GL[1_OTH]="OTH"
)
)
May i know how to combine above 2 into 1 ?
 
Paul

 

 

Need Help

1 Reply

  • amitchandak's avatar
    amitchandak
    Super User
    4 years ago

    admin11 , Try like

     

    _LYTD_OTH_IN =
    var _max = date(year(today())-1,month(today()),day(today()))
    return
    CALCULATE(
    SUM(GL[AMT])*-1,
    FILTER(
    GL,
    GL[1_OTH]="OTH"
    ), DatesYTD(dateadd('DATE'[Date],-1,year)),'DATE'[Date]<=_max)