Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
Hello BI Community:
I am trying to create a calculated column that indicates if data for each school is the most recent based on a completion time.
The current column, isLastEntryforDay is calculated with this code:
isLastEntryforDay = if((TenDayCount[Completion time])=MAXX( FILTER( TenDayCount, TenDayCount[School]=EARLIER(TenDayCount[School]) ), TenDayCount[Completion time]), true(), false() )
However, I really want it to return true if it is the last entry based on the Day column. Not overall.
I would be grateful if anyone could help me modify the DAX (or provide an alternative solution) to accomplish this.
Thank you,
Michael
Solved! Go to Solution.
The solution I used to solve this was to create a new custom column
= Table.AddColumn(#"Replaced Errors", "SchoolDay", each [Day]&","&[Code])
Then, I used the same code as before to determine the most recent entry.
Michael
The solution I used to solve this was to create a new custom column
= Table.AddColumn(#"Replaced Errors", "SchoolDay", each [Day]&","&[Code])
Then, I used the same code as before to determine the most recent entry.
Michael
Hi @Michael1,
However, I really want it to return true if it is the last entry based on the Day column. Not overall.
I'm not sure I understand your requirement totally. Could you be more precisely with it by posting your expected result against the sample data you posted above?
Regards
So, regardless of month and year, if it is the highest day number? So, Jan 30th, 1956 would be the last day versus Dec 29, 2017?
Apologies if I am not understanding something.
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
109 | |
98 | |
80 | |
64 | |
57 |
User | Count |
---|---|
145 | |
110 | |
91 | |
84 | |
66 |