Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and more.
Get startedGrow your Fabric skills and prepare for the DP-600 certification exam by completing the latest Microsoft Fabric challenge.
Hi ALl,
Below is the calculated column but there are lot of blanks which is expected, but I want to replace with NA. Please help
Solved! Go to Solution.
Hi,
I am not sure how your datamodel looks like, but please try the below whether it suits your requirement.
client names =
COALESCE (
MAXX (
FILTER ( Client, Client[Project Number] = Utilization[Project Code] ),
Client[Client Name]
),
"NA"
)
If this post helps, then please consider accepting it as the solution to help other members find it faster, and give a big thumbs up.
Hi @Kiranbc ,
You could try this:-
client names =
VAR result =
MAXX (
FILTER ( Client, Client[Project Number] = Utilization[Project Code] ),
Client[Client Name]
)
RETURN
IF ( OR ( ISBLANK ( result ), result = BLANK () ), "NA", result )
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,
I am not sure how your datamodel looks like, but please try the below whether it suits your requirement.
client names =
COALESCE (
MAXX (
FILTER ( Client, Client[Project Number] = Utilization[Project Code] ),
Client[Client Name]
),
"NA"
)
If this post helps, then please consider accepting it as the solution to help other members find it faster, and give a big thumbs up.
It worked like charrm. Thanks for quick resolution!.
User | Count |
---|---|
83 | |
76 | |
71 | |
69 | |
54 |
User | Count |
---|---|
105 | |
100 | |
91 | |
79 | |
68 |