Forum Discussion

MaadiKemko's avatar
MaadiKemko
Frequent Visitor
10 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
    10 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
    10 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
    10 years ago

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

HarrisMalik's avatar
HarrisMalik
Icon for Continued Contributor rankContinued Contributor
10 years ago

MaadiKemko This can be done easily by adding a column for current month. Some thing like this:

 

In your model add a New Column

 

IsCurrentMonth = IF(MONTH(Sales[Soldon])=MONTH(TODAY()),"Yes","No")

 

Now use your ProductName with aggregation type Count in a visual like Card. Use the newly created column as slicer and its done.

 

Regards

Harris

  • MaadiKemko's avatar
    MaadiKemko
    Frequent Visitor
    10 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
      Icon for Super User rankSuper User
      10 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
      Icon for Continued Contributor rankContinued Contributor
      10 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
        10 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