Forum Discussion

Cgowdar's avatar
Cgowdar
Advocate II
8 years ago
Solved

YTDIssues

Following is the data sample on which i am calculating YTD 

 

Table :

Month     Amount

April        100

June        100

July         100

 

Expected result:

 

 Month     YTD

April          100

May           100 (100+0)

June          200 (100+0+100)

July            300 (100+0+100+100)

 

but i am getting the following result 

 

 Month     YTD

April          100

May           0

June          200 

July            300

 

Any answers on the above issue kindly help asap.

 

 

 

  • Cgowdar's avatar
    Cgowdar
    8 years ago

    This worked :) Thank you so much for this.

     

    I was struggling with the TOTALYTD DAX Function.

     

    But your solution works absolutely fine :)

     

     

3 Replies

    • Cgowdar's avatar
      Cgowdar
      Advocate II

      This worked :) Thank you so much for this.

       

      I was struggling with the TOTALYTD DAX Function.

       

      But your solution works absolutely fine :)