Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
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.
Solved! Go to Solution.
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.
Proud to be a Super User!
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.
Proud to be a Super User!
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
113 | |
99 | |
82 | |
70 | |
60 |
User | Count |
---|---|
149 | |
114 | |
107 | |
89 | |
67 |