how to change field in url?

[Anonymous]

how to change field in url?

Example (URL):  http://vs0022/CronetJVX/pido/getReport?p_pido=50000000681&p_table=50000000300&SHIFT_DATE2=2108202000...

I want to change the dates in the fields DATE2=21082020 > DATE2= 22082020 and DATE1=23082020 > DATE1=24052020 ............

Is it possible?

I don't know how to use  Power BI, I am studying.

[nandukrishnavs · Accepted solution]

@Anonymous 

Try something like this.

Measure =
VAR _date1 = "22082020"
VAR _date2 = "23082020"
VAR _url = "http://vs0022/CronetJVX/pido/getReport?p_pido=50000000681&p_table=50000000300&SHIFT_DATE2=" & _date2 & "&SHIFT_DATE1=" & _date1 & "p_crosscompany=0&p_format=HTML&p_pagination=0&p_showtitle=0&p_showselection=0&p_paperformat=A4&p_userid=TVEN/tven@cronet_cpbritu1"
RETURN
    _url

Instead of hardcoding the date value into variables, you can use your logic to get the dates and assign them to the variables. Example: MAX(date) or SELECTEDVALUE(date) etc.