topic Re: Apply filter on CURRENTGROUP in DAX Commands and Tips

Apply filter on CURRENTGROUP

vs531 — Mon, 23 Jan 2023 19:07:42 GMT

I am trying to calculate the difference between the last and previous observations for each ID. In the dataset, I have multiple observations for each ID over time. As a first step, I want to create a new table with the last and previous dates. I m using GROUPBY, but I cannot apply any filter to CURRENTGROUP. What would be a better approach to the problem?

Thanks

NewTable =

GROUPBY(

table,table[ID],

"LastDate",MAXX(CURRENTGROUP(),table[DATE]),

"PreviousDate", MAXX(FILTER(CURRENTGROUP(), table[DATE] < MAXX(CURRENTGROUP(),table[DATE]),table[DATE] )

))

Re: Apply filter on CURRENTGROUP

amitchandak — Tue, 24 Jan 2023 01:52:26 GMT

vs531 , In case you need a new column

Diff =

var _max = maxx(filter(Table, [ID] = earlier([ID]) && [Date] < earlier([Date]) ) , [Date])
return
[Score]- Maxx(filter(Table, [ID] = earlier([ID]) && [Date] =_max ) , [Score])

Re: Apply filter on CURRENTGROUP

vs531 — Tue, 24 Jan 2023 12:56:56 GMT

Thanks amitchandak