Calculating Sales from a certain day of the month

[Anonymous]

I'm trying to calculate the total sales from the 1st  of the month (1st of january, 1st of february etc). Ignoring all other sales from the other days in the month.

* 1/1/2020

* 1/2/2020

* 1/3/2020

Imagine the measure I currently use is [Total Sales] Which is a SUM(sales). 

My date table is in m/d/yyyy/ hh:mm:ss: but ideally the time would be ignored

I'd then like to adjust the [Total Sales] so it only factors in the sales made on the 1st of each month (Every month, every year)

Any help would be appreciated, thanks a lot!

Regards,

Justin

[NandanHegde]

Hey,
You can create a Flag column indictaing that it is 1st day of the month.
Then in measure : Calculate (sum(sales), FIlter(Flagcolumn=1))