Power BI Current Month Count

Thanks for your reply Harris.

As you mentioned, I have tried to create a custom coloum using Power BI Query Editor.

But I am getting the below error. 

Let me know what is the issue here.

Hi 

You created a column in query mode. For this solution, You need to create a calculated column in your table

After loading your query in data model, select the table and right click.  

Select new column and write this DAX Expression for it to work.

Thanks & Regards,

Bhavesh

MaadiKemko it is a DAX expression which works as BhaveshPatel mentioned. You are trying to use DAX in M Query editor.