Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
3 years ago

How to create a calculated column in one table based on conditions from another table

Hi All, I am looking for an answer to the below question I have while preparing some visuals in Power BI. Appreciate your help and valuable advice on this query. I have data in a table (Users tab...
Need Help
Anonymous's avatar
Anonymous
Not applicable
3 years ago

hi DimaMD ,

 

Unfortunately, it didn't return the correct values as expected.

Anonymous's avatar
Anonymous
Not applicable
3 years ago

Hi DimaMD ,

 

To be more specific:

The problem I am facing with this solution is associated with MAX function. 

MAX('Users'[accountName]) is returing the alphabetically higher value instead of the most frequent user.
MAX('Users'[accountName])