About jase1979

jase1979 · 05-09-2023

I'm trying to achieve something that was reasonably easy in another app dev environment. I have a table with about 10 records, I want to take all of the rows from that column and join the rows into a single row in a column of another table. I could d...

jase1979 · 05-22-2023

I'm getting an unwanted comma in my expression result. SUBSTITUTE(Current Report[Current Comments], "#N", [Name]) The expression above joins all rows from the column "Current Comments", however, it displays a comma in-between every join. I don't want...

jase1979 · 05-22-2023

I meant when I clicked test expression, it showed the result in the correct manner on the left-hand side of the test window, but not on the right-hand side. It seems to be working fine now though.

jase1979 · 05-19-2023

Well, the expression result works, however, it doesn't carry across to the virtual column.

jase1979 · 05-19-2023

Thanks again. I didn't need to use the split function. It worked without.

jase1979 · 05-17-2023

How would I go about including a SUBSTITUTE function in the same expression? e.g Where ever I there is a "#N" replace it with a name from another column.I know that I can do this "SUBSTITUTE( "#N", "#N", "Jase") how do I combine it with the above sol...

My Stats

Anca1212's Bio

Badges jase1979 Earned

Recent Activity

Join all rows if a column into one row in differnt table

Re: Join all rows if a column into one row in differnt table

Re: Join all rows if a column into one row in differnt table

Re: Join all rows if a column into one row in differnt table

Re: Join all rows if a column into one row in differnt table

Re: Join all rows if a column into one row in differnt table