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 l...
Need Help
  • amitchandak's avatar
    amitchandak
    4 years ago

    admin11 , try like

     

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

amitchandak's avatar
amitchandak
Icon for Super User rankSuper User
4 years ago

admin11 , try like

 

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

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

amitchandak 

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

Paul