Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
Is it possible to factor an ANTI JOIN inside GENERATE. I am currently doing this
EVALUATE
VAR __fact =
DATATABLE (
"fact.fact", STRING,
{
{ "a Messi" },
{ "aaa Messi" },
{ "ababa Pele" },
{ "ababan Diego" },
{ "xyz Crisitiano" },
{ "yyy Ronaldo" },
{ "Messi aaa" }
}
)
VAR __exec =
DATATABLE (
"exec.name", STRING,
{
{ "Messi" },
{ "Crisitiano" },
{ "Ronaldo" }
}
)
VAR res =
FILTER (
__fact,
NOT ( [fact.fact] )
IN SUMMARIZE (
GENERATE (
__exec,
FILTER (
__fact,
VAR one =
LEN ( [exec.name] )
VAR two =
RIGHT ( [fact.fact], one )
RETURN
two = [exec.name]
)
),
[fact.fact]
)
)
RETURN
res
I want to avoid
Solved! Go to Solution.
How about this?
res =
FILTER (
__fact,
ISEMPTY (
FILTER (
__exec,
RIGHT ( [fact.fact], LEN ( [exec.name] ) ) = [exec.name]
)
)
)
How about this?
res =
FILTER (
__fact,
ISEMPTY (
FILTER (
__exec,
RIGHT ( [fact.fact], LEN ( [exec.name] ) ) = [exec.name]
)
)
)
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
104 | |
95 | |
80 | |
67 | |
62 |
User | Count |
---|---|
146 | |
110 | |
107 | |
86 | |
63 |