Required Data according to Date and unique ID by Calculating Sum

[patelsa]

I required DateWise Sum from the Actual Data by filtering data and id and using Latest record concept. I required help for creating dax for this. Below table Actal Data is my table and Required Data, i need to display in report,  Latest data according to date and id represent how Actual Data should be filter to achieve result. KIndly help for achieving this

Actual Data					Required Data			Latest data according to date and id
ID	Date		IsReq		Date	Sum(IsReq)		ID	Date		IsReq
1	01-01-15		1		01-01-14	0		2	01-01-14		0
1	01-01-17		1		01-01-15	1		1	01-01-15		1
1	01-01-18		1					2	01-01-14		0
2	01-01-14		0		01-01-16	2		1	01-01-15		1
2	01-01-16		1					2	01-01-16		1
3	01-01-18		0		01-01-17	2		1	01-01-17		1
3	01-01-19		0					2	01-01-16		1
3	01-01-20		1		01-01-18	2		1	01-01-18		1
3	01-01-21		1					2	01-01-16		1
3	01-01-22		1					3	01-01-18		0
4	01-01-20		0		01-01-19	2		1	01-01-18		1
4	01-01-21		0					2	01-01-16		1
4	01-01-22		1					3	01-01-19		0
4	01-01-23		1		01-01-20	3		1	01-01-18		1
4	01-01-24		1					2	01-01-16		1
5	01-01-21		0					3	01-01-20		1
5	01-01-22		1					4	01-01-20		0
5	01-01-23		1		01-01-21	3		1	01-01-18		1
5	01-01-24		1					2	01-01-16		1
								3	01-01-21		1
								4	01-01-21		0
								5	01-01-21		0
					01-01-22	5		1	01-01-18		1
								2	01-01-16		1
								3	01-01-22		1
								4	01-01-22		1
								5	01-01-22		1
					01-01-23	5		1	01-01-18		1
								2	01-01-16		1
								3	01-01-22		1
								4	01-01-23		1
								5	01-01-23		1
					01-01-24	5		1	01-01-18		1
								2	01-01-16		1
								3	01-01-22		1
								4	01-01-23		1
								5	01-01-23		1

[patelsa]

Thank you for the suggesion but It is not working, I am not able to get required result. Another point is that Actual Data is not order by ID wise. 

[dharmendars007]

Hello @patelsa , 

1. Please create a measure for latest data like below..

LatestActualDate =
CALCULATE(
MAX(Table[Actual Date]),
FILTER(Table,Table[ID] = EARLIER(Table[ID])))

2.Create a measure to check if the record is latest and then use it as Visual level filter.

IsLatestRecord =IF(Table[Actual Date] = Table[LatestActualDate],1, 0)

If you find this helpful , please mark it as solution and Your Kudos/Likes are much appreciated!

Thank You

Dharmendar S

LinkedIN