Forum Discussion

admin11's avatar
admin11
Icon for Memorable Member rankMemorable Member
4 years ago
Solved

How 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

  • admin11 , try like

     

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