Md Sohail .

Bleow are of the common spread sheet application.

• Google Sheets - (online and free).
• iWork Numbers - Apple Office Suite.
• LibreOffice -> Calc (free).
• Lotus 1-2-3 (discontinued).
• Lotus Symphony - Spreadsheets.
• Microsoft Excel.
• OpenOffice -> Calc (free).
• VisiCalc (discontinued).

The evaluation context in DAX consider two context for an expression:

• Filter Context: it is a set of filters applied to any iterator or aggregation function in DAX. You can imagine it as a list of values allowed for one or more columns in one or more tables. These filters can be manipulated by using DAX functions such as CALCULATE and CALCULATETABLE, which modify the filter context where a DAX expression is evaluated.
• Row Context: it is the “current row” during a table iteration where a column reference can be evaluated. A calculated column and the expression applied to an iterator are always executed within a row context.

Personally I would use MID() which is a bit shorter and more elegant function. This will find a URL anywhere within the input string - start, middle or end.

For an input string in cell A2 this is the formula:

1. =MID(A2,FIND("http",A2),FIND(" ",A2,FIND("http",A2))-FIND("http",A2))

Description of how it works. First the MID() formula, it extracts text from a string. It takes three inputs: (1) the input string, (2) where to start extracting and (3) the length of the text to extract.

(1) The input string is the contents of cell A2.

(2) The place to start: where “http” is found, FIND(A2,”http”). The value returned to MID() will actually be at the location of the “h” in “http”. This will work for “https” urls too because they still have “http” in them.

(3) Then I do a bit of subtraction. URLs do not have any spaces in them. So if I can find the first space after the URL I can use that to get the length of the URL. I use FIND() to find a space. FIND() has an optional third argument which is to start looking at the location I desire. So I set that location to be where “http” was found using the same formula as before. Since that will return the location within the whole input string and not the length of just the URL I need to subtract from it. I subtract the location of “http” using FIND("http",A2).