Find first appearance of a value and make a table

[Naz]

I have a huge table of patients for the last 6 months or so. I want to find out who are brand new patients last month or the month before. It should be pretty straight forward but can't really get it. Thank you so much in advance for your help.

[Naz]

[Anonymous]

Hi @Naz Please try below code

Table = SUMMARIZECOLUMNS(Data[Patient],"FirstDate",MIN(Data[Date]),"Medicine",CALCULATE(MAX(Data[Medicine]),FILTER(Data,Data[Date]=MIN(Data[Date]))))