Forum Discussion
admin11
Memorable Member
4 years agoHow to get QTD_REV expression ?
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
admin11 , try like
_QTD_REV = CALCULATE(GL[AMOUNT],DATESQTD(dateadd('Date'[Date],-1,QUARTER)), GL[1_REV] = "REV")
2 Replies
- amitchandak
Super User
admin11 , try like
_QTD_REV = CALCULATE(GL[AMOUNT],DATESQTD(dateadd('Date'[Date],-1,QUARTER)), GL[1_REV] = "REV")
- admin11
Memorable Member