Earn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.
Estimados todos
He usado el siguiente dax, pero todavía me estoy quedando en blanco, no estoy seguro de cómo resolver esto, ¿alguien puede ayudar?
Competencia EP =
FILTRO (
DISTINTO (
UNIÓN (
DISTINTO ( 'Portfolio report FY22'[Competencia de engagement partner] ),
DISTINTO ( 'Portfolio report FY21'[Competencia de socio de compromiso] )
)
),
NO ( ISBLANK ( 'Portfolio report FY22'[Competencia de engagement partner] ) )
)
Solved! Go to Solution.
@vjnvinod Quizás:
EP Competency =
FILTER (
DISTINCT (
UNION (
DISTINCT ( 'Portfolio report FY22'[Engagement Partner Competency] ),
DISTINCT ( 'Portfolio report FY21'[Engagement Partner Competency] )
)
),
'Portfolio report FY22'[Engagement Partner Competency] <> ""
)
Esto funciona, muchas gracias
@vjnvinod Quizás:
EP Competency =
FILTER (
DISTINCT (
UNION (
DISTINCT ( 'Portfolio report FY22'[Engagement Partner Competency] ),
DISTINCT ( 'Portfolio report FY21'[Engagement Partner Competency] )
)
),
'Portfolio report FY22'[Engagement Partner Competency] <> ""
)
User | Count |
---|---|
2 | |
2 | |
1 | |
1 | |
1 |