Forum Discussion

MiKeZZa's avatar
MiKeZZa
Post Patron
9 years ago

Manipulating column on USERPRINCIPALNAME()

Hi all,   I want to make something like this:   TABLE: Field 1 Field 2 Field 3   This table must have a Field 4 which contains Field 1 if the logged in person is in Active Directory Group 'G...
Need Help
vanessafvg's avatar
vanessafvg
Community Champion
9 years ago

can i see your dax code with an example of the data

MiKeZZa's avatar
MiKeZZa
Post Patron
9 years ago

We've mailed and Vanessas solution is to combine everything in 1 table. A solution that absolute will work, but not what I'm looking for...

 

I'm afraid I'm looking for something that is not possible....

  • vanessafvg's avatar
    vanessafvg
    Community Champion
    9 years ago

    out of curiosity why does combining the tables not work for you?

    • MiKeZZa's avatar
      MiKeZZa
      Post Patron
      9 years ago

      I think it will work, but it's not what I was hoping for. This gives me 2 'facttables', only for something easy (in other languages/tools) as this:

       

      if (username IN (list of people that are manager)
{
           FieldA
}
else
{
           FieldB
}

      So I'm still hoping to solve it another way, that is also easier to understand for other people at a later moment....