Forum Discussion

alfredorhz's avatar
alfredorhz
Helper I
2 years ago
Solved

Extract text from string

HI Community I have a string, that I get from a PowerShell script, This script creates a report from SharePoint page views, so, in the context of the information the audit data has a very large stri...
Need Help
Show and Tell
Tips and Tricks
  • alfredorhz's avatar
    alfredorhz
    2 years ago

    Thanks guys

    I resolve this with a dax,

    Extract =
    var fin = LEFT(Table[AuditLog], SEARCH("http",Table[AuditLog])-1)
    var Lentf = LEN(fin)
    var Midd = MID(Table[AuditLog], Lentf, 250)
    #This is a delimiter before .aspx or .pdf acces file
    var     http = SEARCH(",", Midd)
    return
    LEFT(Midd, http)
Ahmedx's avatar
Ahmedx
Super User
2 years ago

Share sample pbix file to help you.

alfredorhz's avatar
alfredorhz
Helper I
2 years ago

Hi Ahmedx
Thanks
It´s a little dificult share this files, you know, company sharing restrictions