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.
Hi,
I am trying to create a calculated column to create COALESCE(SITEADDR.STADDRESS1,TRANSFIL.ADDR_VAT1) or If(Isblank(SITEADDR.STADDRESS1) ,TRANSFIL.ADDR_VAT1 , SITEADDR.STADDRESS1). but this is not working.
So I have tried to merging tables TRANSFIL and SITEADDR but is still not working because tranfil table is very big.
this is the relationsgip between them.
How can I solve this?
regards
Solved! Go to Solution.
Hi @Anonymous ,
You could try this:-
column =
COALESCE ( SITEADDR[STADDRESS1], RELATED ( TRANSFIL[ADDR_VAT1] ) )
or
column =
IF (
SITEADDR[STADDRESS1] = BLANK (),
RELATED ( TRANSFIL[ADDR_VAT1] ),
SITEADDR[STADDRESS1]
)
Note:- I am considering you are creating a column in SITEADDR Table.
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 @Anonymous ,
Whether the advice given by @Samarth_18 has solved your confusion, if the problem has been solved you can mark the reply for the standard answer to help the other members find it more quickly. If not, please point it out.
Looking forward to your feedback.
Best Regards,
Henry
Hi @Anonymous ,
You could try this:-
column =
COALESCE ( SITEADDR[STADDRESS1], RELATED ( TRANSFIL[ADDR_VAT1] ) )
or
column =
IF (
SITEADDR[STADDRESS1] = BLANK (),
RELATED ( TRANSFIL[ADDR_VAT1] ),
SITEADDR[STADDRESS1]
)
Note:- I am considering you are creating a column in SITEADDR Table.
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
help please
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 |
---|---|
105 | |
93 | |
75 | |
62 | |
50 |
User | Count |
---|---|
146 | |
109 | |
106 | |
88 | |
61 |