Forum Discussion
Get value from a table column - concisely
I'm coming from R where for a table called 'tbl' we can get a value like this:
tbl[i, j]
or if the table only has one row
tbl[j]
Is there something similar in DAX?
I've been using
FIRSTNONBLANK(tbl[j], 1)
and this gets unreadable fast since I'm using a lot of values from the table.
Please note - there are some differences if j is a number, string or variable name - in this case please assume j is a string value.
## Updated 30 July 2024 ##
Please find example attached. In the example (sorry it seems no option to attach a PBIX), the user selects a country and the country and capital are shown as a crumb on the right side. The measure DAX is also shown in a text box bottom left, and a preferred DAX (which doesn't work but indicates my intent) is on the right.
and this gets unreadable fast since I'm using a lot of values from the table.
Please note - there are some differences if j is a number, string or variable name - in this case please assume j is a string value.
## Updated 30 July 2024 ##
I'm flexible with the syntax, the main problem with the working approach besides the verbosity is that I have to get the FIRSTNONBLANK value twice, and if it is a big table, then this is not as performant as being able to get a single row and then take the values from that row.
3 Replies
Can you please share a pbix or some dummy data that keep the raw data structure with expected results? It should help us clarify your scenario and test to coding formula.
I can't see an option to share a PBIX... image, video is there, but not option to share a file.
