Check your eligibility for this 50% exam voucher offer and join us for free live learning sessions to get prepared for Exam DP-700.
Get StartedDon't miss out! 2025 Microsoft Fabric Community Conference, March 31 - April 2, Las Vegas, Nevada. Use code MSCUST for a $150 discount. Prices go up February 11th. Register now.
Hi,
I have 4 columns
ID Name Datetimestamp Value
1 BMI 2020/08/04 12:23:12 12
1 BMI 2020/08/11 08:22:10 15
2 BMI 2020/08/11 12:25:12 20
3 BMI 2020/08/11 12:26:12 22
4 BMI 2020/08/11 12:21:12 13
4 BMI 2020/08/11 12:23:12 14
Output:
ID Name Datetimestamp Value
1 BMI 2020/08/11 08:22:10 15
2 BMI 2020/08/11 12:25:12 20
3 BMI 2020/08/11 12:26:12 22
4 BMI 2020/08/11 12:23:12 14
I need to see only latest record by ID using DAX .
Solved! Go to Solution.
@Anonymous
you can also create a new table
Table 2 = ADDCOLUMNS(SUMMARIZE('Table','Table'[ID],'Table'[Name ],"datetimestamp",MAX('Table'[Datetimestamp ])),"value",MAXX(FILTER('Table','Table'[Datetimestamp ]=[datetimestamp]),'Table'[Value]))
Proud to be a Super User!
Hi @Anonymous ,
take a look at the following solution:
Last DateTimeStamp = LASTNONBLANKVALUE('Table'[Datetimestamp],MAX('Table'[Datetimestamp]))
Value that belongs to Last = LASTNONBLANKVALUE('Table'[Datetimestamp],MAX('Table'[Value]))
Regards FrankAT
@Anonymous
you can also create a new table
Table 2 = ADDCOLUMNS(SUMMARIZE('Table','Table'[ID],'Table'[Name ],"datetimestamp",MAX('Table'[Datetimestamp ])),"value",MAXX(FILTER('Table','Table'[Datetimestamp ]=[datetimestamp]),'Table'[Value]))
Proud to be a Super User!
@Anonymous , use these two with ID and name in a visual table
Value new lastnonblankvalue(Table[Datetimestamp], max(Table[Value]))
Datetimestamp new = lastnonblank(Table[Datetimestamp], blank())
@Anonymous - Seems like you want a selector like a Complex Selector, https://community.powerbi.com/t5/Quick-Measures-Gallery/The-Complex-Selector/m-p/1116633#M534
In your case it should be along the lines of:
Selector =
VAR __Date = MAX('Table'[Date])
VAR __Name = MAX('Table'[Name])
VAR __MaxDate = MAXX(FILTER(ALL('Table'),[Name]=__Name),[Date])
RETURN
IF(__Date = __MaxDate,1,0)
You can thing filter using Selector.
IF(
March 31 - April 2, 2025, in Las Vegas, Nevada. Use code MSCUST for a $150 discount! Prices go up Feb. 11th.
Check out the January 2025 Power BI update to learn about new features in Reporting, Modeling, and Data Connectivity.
User | Count |
---|---|
142 | |
80 | |
64 | |
52 | |
48 |
User | Count |
---|---|
212 | |
89 | |
79 | |
68 | |
60 |