Forum Discussion

ny326n's avatar
ny326n
Frequent Visitor
8 years ago
Solved

Error in custom column in query editor

Hello everyone!   I have a table with last active dates:  User name , Last active date   What I want to do is group customers according to last active date; however, I have not found a way to do...
Need Help
  • prateekraina's avatar
    prateekraina
    8 years ago

    ny326n,

     

    What about the measure option then? That can be done i guess.
    Also, you can replace errors with "No Data" as you mentioned. Go to "Transform" tab and click on "Replace Values" > "Replace Errors"



    Please read my previous reply till end.

prateekraina's avatar
prateekraina
Memorable Member
8 years ago

Hi ny326n,

 

In order to remove errors, you can click on your column and then click on "Remove Rows" > "Remove Errors"

Hope this helps,

 

 

 

Also, if you do not want to achive this in Query Editor, there is a  very simple way of doing this by creating a measure.

GroupBYDate = SUMX(SUMMARIZE(Table1,Table1[Date],"CountOfUsers",COUNT(Table1[User])),[CountOfUsers])

Replace column and table names as per your dataset and it should work. Here are the screenshots:

 

 

prateekraina

  • ny326n's avatar
    ny326n
    Frequent Visitor
    8 years ago

    Thank you for you reply.

     

    However, I do not want to remove the rows that contains an error, because I still like to keep the client name in the report although it does not have a date. I only want to change the error to for exampe "No date" so I don't have to see the error each time I refresh the data.

     

     

    • prateekraina's avatar
      prateekraina
      Memorable Member
      8 years ago

      ny326n,

       

      What about the measure option then? That can be done i guess.
      Also, you can replace errors with "No Data" as you mentioned. Go to "Transform" tab and click on "Replace Values" > "Replace Errors"



      Please read my previous reply till end.

      • ny326n's avatar
        ny326n
        Frequent Visitor
        8 years ago

        Thanks a lot! This works. I will also try the measure option, it might be better.