YTDIssues

[Cgowdar]

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.

[Ashish_Mathur · Accepted solution]

Hi,

You may refer to my solution here.

Hope this helps.

[Ashish_Mathur · Accepted solution]

Hi,

You may refer to my solution here.

Hope this helps.

[Cgowdar · Accepted solution]

This worked 🙂 Thank you so much for this.

I was struggling with the TOTALYTD DAX Function.

But your solution works absolutely fine 🙂

[Ashish_Mathur]

You are welcome.