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.
I am trying to create an if statement to see if one value on a table is blank and another value on another table equals whatever. I am getting the result as follows, does anyone know how to resolve this issue?
Solved! Go to Solution.
Hi @Michaelbean21 ,
Please try this:-
Estimated premius bank =
IF (
FACT_BookOfBusiness[Estimated Premius] = BLANK ()
&& RELATED ( DIM_LineStatus[Line Status Code] ) IN { "AQR", "CAI", "CCQ" ....},//add your values of if condition inside " ".
"Audit",
"No Audit"
)
Thanks,
Samarth
Best Regards,
Samarth
If this post helps, please consider accepting it as the solution to help the other members find it more quickly.
Appreciate your Kudos!!
Connect on Linkedin
Hi @Michaelbean21 ,
Please try this:-
Estimated premius bank =
IF (
FACT_BookOfBusiness[Estimated Premius] = BLANK ()
&& RELATED ( DIM_LineStatus[Line Status Code] ) IN { "AQR", "CAI", "CCQ" ....},//add your values of if condition inside " ".
"Audit",
"No Audit"
)
Thanks,
Samarth
Best Regards,
Samarth
If this post helps, please consider accepting it as the solution to help the other members find it more quickly.
Appreciate your Kudos!!
Connect on Linkedin
Thank you much for your help on this! Been trying to figure this out for over a week now.
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 |
---|---|
111 | |
94 | |
83 | |
67 | |
59 |
User | Count |
---|---|
151 | |
121 | |
104 | |
87 | |
67 |