Passing run time parameters in power bi reports

[tarun912]

Hi, 

I would like to ask one thing that is there any provision of passing runtime parameters in power reports ?
Like in the case of jaspersoft, we can pass runtime parameters, is there any optio nin power bi also ?

I am attaching the jasper query here for reference.
Hope to hear from you soon.
Thanks !

Query :

WHERE $X{IN, PRODUCTNAME, PRODUCT} AND CHALLENGEDTIMESTAMP BETWEEN LAST_DAY(ADD_MONTHS(TO_DATE($P{DATE_STR},'DD-MON-YYYY'),-13))+1

AND LAST_DAY(ADD_MONTHS(TO_DATE($P{DATE_STR},'DD-MON-YYYY'),-1))

AND $X{IN, INITCAP(CLIENTNAME), Client_Names}

AND

(SUBSTR(ORIGINATOREMAIL,INSTR((ORIGINATOREMAIL),'@',1)) like (select DISTINCT SUBSTR(ORIGINATOREMAIL,INSTR((ORIGINATOREMAIL),'@',1)) from CORE_DATACHALLENGE.MVIEW_PRICING_CHALLENGES

WHERE ENCRYPTED_EMAIL =  $P{CLIENT_EMAIL} )

OR encrypted_domain =$P{d})

GROUP BY TO_CHAR(CHALLENGEDTIMESTAMP,'YYYYMM'

[Icey]

Hi @tarun912 ,

If I understood you corrcetly, VAR and RETURN are what you want. You can refer to these documents:

VAR: The best thing to happen to DAX since CALCULATE()

Variables in DAX

Best Regards,

Icey

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.