Power BI is turning 10! Tune in for a special live episode on July 24 with behind-the-scenes stories, product evolution highlights, and a sneak peek at what’s in store for the future.
Save the dateEnhance your career with this limited time 50% discount on Fabric and Power BI exams. Ends August 31st. Request your voucher.
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 |
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.
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
Check out the July 2025 Power BI update to learn about new features.
User | Count |
---|---|
23 | |
7 | |
7 | |
6 | |
6 |
User | Count |
---|---|
27 | |
12 | |
10 | |
9 | |
6 |