Segmenting for all dates before current month

[NZemel]

How do you set up that Power BI in query editior will automatically go back a month and take everything from before the current month?

Is this the sort of thing which I will need some DAX?

[v-caliao-msft · Accepted solution]

Hi @NZemel,

If you need to display only current month data, you can add a calculated column use the DAX below.
Column = IF(FORMAT('Table2 (2)'[Date],"YYYYMMM")=FORMAT(TODAY(),"YYYYMMM"),"Current Month","Hisstory Data")

Regards,

Charlie Liao