Forum Discussion

bust0sos's avatar
bust0sos
New Member
4 years ago
Solved

Yes/No column for rows with the same Name

Good morning everyone, I`m having some issues trying to find the correct formula in Power BI.   I have a large database and I want to analyse the group of people who don't speak Spanish.     For...
Need Help
  • amitchandak's avatar
    amitchandak
    4 years ago

    bust0sos , Try a new DAX column

     

    var _cnt = countx(filter(Table, [Name] = earlier([Name]) && [Language] = "Spanish"),[Name])
    return
    if(isblank(_cnt), "No", "Yes")

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

bust0sos , Try a new DAX column

 

var _cnt = countx(filter(Table, [Name] = earlier([Name]) && [Language] = "Spanish"),[Name])
return
if(isblank(_cnt), "No", "Yes")