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 have the following code that works (VAR X = CONCATENATEX(Table, Table[Column] & " - " & Table[Column], "; ", [Table Column], DESC) ---however sometimes my result looks like this:
Ex. 1: Client ABC - 0; -; or
Ex. 2: -;
Basically it tries to concatenate data from one column (description) based off of the id from another column (id) - but while it matches on the id the description column is blank... So I get the ugly -; without anything following it.. So how can I check first whether there's an actual value before attempting to concatenate.. I'm new to DAX so don't know the syntax at all.
Thanks,
I simply want to check if current row Table[Column] is blank, null, etc. before doing this step: Table[Column] & " - " & Table[Column], "; ", [Table Column].... Need syntax...
Solved! Go to Solution.
@arelf27 wrote:
I have the following code that works (VAR X = CONCATENATEX(Table, Table[Column] & " - " & Table[Column], "; ", [Table Column], DESC) ---however sometimes my result looks like this:
Ex. 1: Client ABC - 0; -; or
Ex. 2: -;
Basically it tries to concatenate data from one column (description) based off of the id from another column (id) - but while it matches on the id the description column is blank... So I get the ugly -; without anything following it.. So how can I check first whether there's an actual value before attempting to concatenate.. I'm new to DAX so don't know the syntax at all.
Thanks,
I simply want to check if current row Table[Column] is blank, null, etc. before doing this step: Table[Column] & " - " & Table[Column], "; ", [Table Column].... Need syntax...
Try to apply a filter to the table.
New_Measure = CONCATENATEX ( FILTER ( 'Table', 'Table'[description] <> BLANK () && 'Table'[id] <> BLANK () ), 'Table'[description] & "-" & 'Table'[id], ";", 'Table'[description], ASC )
@arelf27 wrote:
I have the following code that works (VAR X = CONCATENATEX(Table, Table[Column] & " - " & Table[Column], "; ", [Table Column], DESC) ---however sometimes my result looks like this:
Ex. 1: Client ABC - 0; -; or
Ex. 2: -;
Basically it tries to concatenate data from one column (description) based off of the id from another column (id) - but while it matches on the id the description column is blank... So I get the ugly -; without anything following it.. So how can I check first whether there's an actual value before attempting to concatenate.. I'm new to DAX so don't know the syntax at all.
Thanks,
I simply want to check if current row Table[Column] is blank, null, etc. before doing this step: Table[Column] & " - " & Table[Column], "; ", [Table Column].... Need syntax...
Try to apply a filter to the table.
New_Measure = CONCATENATEX ( FILTER ( 'Table', 'Table'[description] <> BLANK () && 'Table'[id] <> BLANK () ), 'Table'[description] & "-" & 'Table'[id], ";", 'Table'[description], ASC )
Thanks, this is exactly what I needed.
Thanks using Filter did the trick!
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 |
---|---|
14 | |
2 | |
2 | |
1 | |
1 |