How to get QTD_REV expression ?

[admin11]

Hi All,

I have below expression working fine , it can return YTD revenue amount correctly :-
_YTD_REV = CALCULATE(CALCULATE(GL[AMOUNT],DATESYTD('Date'[Date],"12/31")), GL[1_REV] = "REV")

I like to change the above expression to QTD base on above  YTD expression :-
_QTD_REV = CALCULATE(CALCULATE(GL[AMOUNT],DATESQTD('Date'[Date],-1,QUARTER)), GL[1_REV] = "REV")

I get error msg below :-

Hope some one can share with where go wrong ?

Payl Yeo

[amitchandak · Accepted solution]

@admin11 , try like

_QTD_REV = CALCULATE(GL[AMOUNT],DATESQTD(dateadd('Date'[Date],-1,QUARTER)), GL[1_REV] = "REV")

[admin11]

@amitchandak 

Thank you for your help , now you are getting better and better.

Paul