Forum Discussion
Syntax to user USERPRINCIPAL name function in M
Has anyone used this function to filter a table in Power Query? I thought it would be as simple as this: But, I'm getting an expression error I can't resolve. As usual, thanx in adva...
USERPRINCIPALNAME is a DAX function
You cannot use it in the query editor
Crap. Of course. Duh.
I don't suppose there's any way to create a Power Query LIST from a filtered DAX table either.
Frustrating.