The ultimate Fabric, Power BI, SQL, and AI community-led learning event. Save €200 with code FABCOMM.
Get registeredCompete to become Power BI Data Viz World Champion! First round ends August 18th. Get started.
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.
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]))))
User | Count |
---|---|
17 | |
8 | |
7 | |
6 | |
6 |
User | Count |
---|---|
26 | |
13 | |
12 | |
9 | |
8 |