Forum Discussion

MaadiKemko's avatar
MaadiKemko
Frequent Visitor
9 years ago
Solved

Power BI Current Month Count

    Hi all,   I am a newbie in Power BI. Please find the below product list and the date sold out. Can any one help me to find the the No. of Products sold in the "Current Month" using Power BI...
Need Help
  • MaadiKemko's avatar
    MaadiKemko
    9 years ago

    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.

  • BhaveshPatel's avatar
    BhaveshPatel
    9 years ago

    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

  • HarrisMalik's avatar
    HarrisMalik
    9 years ago

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

MaadiKemko's avatar
MaadiKemko
Frequent Visitor
9 years ago

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.

HarrisMalik's avatar
HarrisMalik
Continued Contributor
9 years ago

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

  • MaadiKemko's avatar
    MaadiKemko
    Frequent Visitor
    9 years ago

     

     

    I  have done changes as you mentioned.

    There is one currection in the formula. If we use the above mentioned formula, will get month but that will not check the year.

    So I modified the formula as below and now the result is showing as expected.

     

     

    Thanks a lot HarrisMalik and BhaveshPatel