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
DimaMD's avatar
DimaMD
Icon for Solution Sage rankSolution Sage
3 years ago

hi Anonymous Create a calculated column in the Devices table

 

Max user = 
CALCULATE (
MAX ('UsersTable'[User] ),
FILTER (
'UsersTable',
[Difference] = 'UsersTable'[Difference]
&& [deviceID] =  DevicesTable[deviceID]
)
)

 

 

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])