Passing Multiple parameters to Oracle Query

[rocky09]

I have this below Oracle Query using in PowerBI.  I need to Pass two Parameters to the Bold Highlighted.

With mgnno As
   (Select Plan_Number From ALLSub.Z_MGT_Roylce_Log@KGN_OP
    Where MGT_Source = 'USB' and Year_Month = 201805 -- Recent Year Month
    Minus
    Select Plan_Number From ALLSub.Z_MGT_Roylce_Log@KGN_OP
    Where MGT_Source = 'USB' and Year_Month = 201804) -- Previous Year Month
Select Distinct substr(M.Year_Month,0,4) || '-' || substr(M.Year_Month,5) Ld_Yr_Mth,
    M.account_name, M.Subscriber_name, M.Address, M.Country, Substr(M.Plan_Status, 10) Status
From ALLSub.Z_MGT_Roylce_Log@KGN_OP M
inner join mgnno l on l.Plan_Number = z.Plan_Number

I have created Two Parameters. One is RecentYearMonth and other is PreviousYearMonth.

My question is, how do i pass the above Parameters to the above query.  Also, I want this to be dynamic. I want to compare the data with two given months.  , Any idea, how do i achieve this.

 @Phil_Seamark @MFelix @Anonymous @Zubair_Muhammad

Thank you in advance,

[v-yuta-msft]

Hi rocky09,

For details about Dynamic Data Masking in Query Parameter, please refer to this blog: 

http://biinsight.com/power-bi-desktop-query-parameters-part2-dynamic-data-masking-and-query-paramete...

Regards,

Jimmy Tao

[rocky09]

@v-yuta-msft

Thank you for the reply. I will check .  So, there is no alternative for this situation?