This Month or Greater

[aashton]

I want to filter a visual on everything with a start date of this month or greater, can you help with the syntax?

[v-xiaoyan-msft]

Hi@aashton,

Has your problem been solved? if so, please consider Accept a correct reply as the solution to help others find it. 

Thank you very much for your cooperation.

Best Regards,

Caitlyn Yan

[amitchandak · Accepted solution]

@aashton , start date of this month

eomonth(today(),-1)+1

You can use in a measure like

measure  =

var _min = eomonth(today(),-1)+1

return

calculate(sum(Table[value]), filter(Table, Table[date] > _min))