I want to show last couple of line from a column out of many lines in a table visual in power bi

[Anonymous]

Dear Team,

I have an input excel file for my PBI dashboard that has multiple rows & Columns, in one column name called "Update", & in that column our team mates are updating latest status ( text inputs ) on each week. so this column is having multiple lines becoming long list week after week, I have created a simple table visual from the input excel file and in this visuals I want to show last week updats only which contains only couple of lines at each row.

Best Regards
Manik Nag

[lbendlin]

You don't need identifiers.  You need to search for the last occurence of the Line Feed character in your text - character code 10  as I described above.

Post some sample data.

[Anonymous]

Dear Ibendlin,
Can you please provide me the code ( add custome column with M Code )

[lbendlin]

Yes, right after you provide sample data.

Here's how it would look like:

    #"Added Custom1" = Table.AddColumn(#"Added Custom", "Last Line", each  Text.AfterDelimiter([Multi Row Text Column],Character.FromNumber(10),{1, RelativePosition.FromEnd}))

Note: you can also use "#(lf)" if you want code that is harder to read.

[Anonymous]

Kindly provide your e mail id if possible or let me know how to share the sample PBIX file

[Anonymous]

Kindly provide your e mail id if possible so that I can send you sample pbix through we transfer

[lbendlin]

Easiest would be to create another column in Power Query (during data load) that uses

Text.PositionOf - PowerQuery M | Microsoft Docs

to find the last carriage return or line feed  (or the absence of it)  and then use Text.Last to get the string after it  (or the entire string if it is only a single line).

Doing this in DAX is also possible but a  bit more convoluted.

[Anonymous]

Thank you for replying , but all text are very dynamic , so I do not have any identifier , all I need to extract last couple of line s from last, anyway kindly provide some example so that I can try further, currently I have only one Identifier "Mar" (i'e'that's the only common text ) from next month it will be "April"