A function which is passed in an If statement in M Code

[I_cant_read]

Hi there,

I'm fairly new to M Code and DAX... I would like to know how to approach this problem.

Basically I want to extract data using a do until or an if statement.

example:

www.website.com/VariableA/1
www.website.com/VariableB/1
www.website.com/VariableB/2
www.website.com/VariableC/1

something like

(VariableLetter)=>
Source = Web.Page(Web.Contents("https://www.website.com/Variable "&VariableLetter&" /1"))
looping through 1 to ... any number then stops when it returns a null.

Cheers.