Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
4 years ago
Solved

If Condition for Text not recognizing column name

I have a text column USERID for which I want to determine part of a USERID based on IF condition. However, I tried as both column and measure, but getting error "can not find column, please use aggre...
  • v-robertq-msft's avatar
    v-robertq-msft
    4 years ago

    Hi, Anonymous 

    According to your DAX formula and error message, it seems that the problem occurs because of one missing parenthesis in the function LEN(MAX('Sessions'[Known Visitor Id]):

     

    I suggest you to change the DAX formula like this and check if the problem can disappear:

    Known Visitor Id = 

RIGHT(MAX('Sessions'[Known Visitor Id]),LEN(MAX('Sessions'[Known Visitor Id])) - FIND("\",MAX('Sessions'[Known Visitor Id])))

     

    And you can get what you want.

     

    If you still have a problem, you can post some sample data(without sensitive data) and your expected result.

    How to Get Your Question Answered Quickly 

    Thank you very much!

     

    Best Regards,

    Community Support Team _Robert Qin

    If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

VahidDM's avatar
VahidDM
Icon for Super User rankSuper User
4 years ago

Hi Anonymous 

 

Use MAX(Sessions[column name] in the measure.

 

If this post helps, please consider accepting it as the solution to help the other members find it more quickly.
Appreciate your Kudos!!
LinkedIn: www.linkedin.com/in/vahid-dm/

 

 

Anonymous's avatar
Anonymous
Not applicable
4 years ago

Hello VahidDM,

Thank you for your response, but when I try putting aggreagte function like MAX(Sessions[column name]) I get error 'can not convert value of type text to Number'. 

I need to work in DirectQuery mode only.

 

I believe to apply aggregate function it needs to be numberic data, however my column contains text.