Calculate YTD based on measure

[ttansriw]

Hi All,

 I have 1 table  and the data like this

Date	Attribute	Value	Index
22/01/2021	TR1	100	1
23/01/2021	TR1	120	2
24/01/2021	TR1	130	3
26/01/2021	TR1	140	4
22/01/2021	TR2	200	1
23/01/2021	TR2	202	2
24/01/2021	TR2	203	3
26/01/2021	TR2	205	4

I calculate the difference via index by this formula

diff =

var _nextID = sum(tMain[Index]) +1

var _tr = SELECTEDVALUE(tMain[Attribute])

var _result =CALCULATE(

                    calculate(sum(tMain[Value]),

                    FILTER(all(tMain),tMain[Index] = _nextID),

                    tMain[Attribute]= _tr

) -

                   CALCULATE(

                   sum(tMain[Value]),

                   tMain[Attribute] =_tr

)

)

return

if(_result <0 ,0,_result)

and I got the output of what I want

---------------------------------------------------

Then I want to calculate YTD

diff YTD =  TOTALYTD([diff],tCalendar[Date])

This is the output

----------------------------------------

and this is what I want

I want to find YTD and MTD with the same attribute.

The result isn't going out. Do I need to fix the diff measure or anything else?

Anyone help me, please!! 

Thank you!

[amitchandak]

@ttansriw , Make sure you take Max for value.   and tCalendar is marked as date tbale and dates in the visual are used from tCalendar

[ttansriw]

@amitchandak 
I summarize all the data so all the data is maxed with the unique date in the main table

and marked as a date in a table calendar already.

The output appears like in the picture.

[amitchandak]

@ttansriw ,Can you share sample data and sample output in table format? Or a sample pbix after removing sensitive data.

[ttansriw]

@amitchandak  here is the link

https://www.dropbox.com/s/7wm8wg58dq1xyjl/test.pbix?dl=0

I want to calculate the diff between rows by each attribute and then calculate ytd/mtd for each attribute.