How to pick rows by groups with newest date in specific period of time

[Anonymous]

Hello,

Regarding table with data below, I would like to ask:

how I could create report table, where I could pick specifick period of time (for example 1/14/2020-1/20/2020) and then pick the newest rows regarding "Group" name? 

Project	Group	Group_status	Date
Main	main_1gr	Passed	1/11/2020
Main	main_1gr	Failed	1/13/2020
Main	main_3gr	Failed	1/14/2020
Main	main_2gr	Failed	1/15/2020
Main	main_1gr	Failed	1/16/2020
Main	main_1gr	Failed	1/19/2020
Sys	sys_1gr	Failed	1/11/2020
Sys	sys_2gr	Failed	1/13/2020
Sys	sys_1gr	Passed	1/14/2020
Sys	sys_2gr	Failed	1/15/2020
Sys	sys_2gr	Failed	1/17/2020
v104	v104_1gr	Failed	1/14/2020
V104	v104_1gr	Passed	1/17/2020
v104	v104_1gr	Failed	1/18/2020
v20	v20_1gr	Failed	1/14/2020
v20	v20_1gr	Passed	1/20/2020
v20	v20_1gr	Failed	1/21/2020
v20	v20_1gr	Failed	1/22/2020

[dustinn · Accepted solution]

Not really good at DAX but make a measure then that will serve as your table filter.

Measure1 =
VAR MaxDate =
CALCULATE (
MAX ( [Date] ),
ALLSELECTED ( 'Table'[Date], 'Table'[Group], 'Table'[Group_status] )
)
RETURN
CALCULATE ( MAX ( [Date] ), FILTER ( 'Table', [Date] = MaxDate ) )

[Anonymous]

Thank you, @dustinn  , your measure helped me! Only, I replaced 'Table'[Group] to 'Table'[Project].

[amitchandak]

create a measure like this and use in your visual

calculate(countrow(table),
	filter(summarize(table,table[Group],"_maxdt",max(table[date]),"_maxGp",max(table[Group])),
			table[Group]=[_maxGp] && max(table[date]=_maxdt)))

Appreciate your Kudos. In case, this is the solution you are looking for, mark it as the Solution. In case it does not help, please provide additional information and mark me with @
Thanks. My Recent Blog -
Winner-Topper-on-Map-How-to-Color-States-on-a-Map-with-Winners , HR-Analytics-Active-Employee-Hire-and-Termination-trend
Power-BI-Working-with-Non-Standard-Time-Periods And Comparing-Data-Across-Date-Ranges

Connect on Linkedin