Concatenate & Count data for every month in 1 virtual column

[drfuadj]

Hello, Im trying to configure a basic stats pages for my app. And one of it is to have a total COUNT NUMBER of UNIQUE ID visited in each month

By using virtual column, I'm using this expression to count the total uniqueid for each month:

CONCATENATE("March 2023: Total ", COUNT(UNIQUE(SELECT(DATAWOUND[IC NUMBER],
AND([TIMESTAMP] >= "03/01/2023"], [TIMESTAMP] <= "04/01/2023"),TRUE))), " patients")

My questions are:
1- Is there a better way i can count total uniqueid in each month? The above expression works but Im not sure it is the best way to count the respected datas.

2- How can i automate so that it can count the coming months automatically in 1 virtual column? 

3- Can i combine data for EACH MONTH in 1 virtual column for example like this:
     March 2023: total 10 patients
     April 2023: total 23 patients
     May 2023: total 14 patients

Hope anyone can enlighten me up as im newbie in this. Thanks!

[Marc_Dillon]

Set up a table for months, and put the virtual column on that table, replacing the hard coded month values with values referencing each month record.