Forum Discussion

SHIV_SHANKAR's avatar
SHIV_SHANKAR
New Member
2 months ago

Dynamic M query Date parameter not working for After or before slicer style

Hi, I am working with an Oracle database using a Dynamic M Query Parameter in Power BI. I have created the parameter and handled it in the M code. In the Power BI UI, I created a Date table to hand...
Need Help
Show and Tell
Tips and Tricks
Kiran-7312's avatar
Kiran-7312
Icon for Helper I rankHelper I
2 months ago

Hi, Could you please share a screenshot of your parameter configuration and the M query where the date filter is applied? For Dynamic M Query Parameters, the parameter data type should match the column data type exactly. If you're using an **After** or **Before** filter, also verify that both the parameter and the source column are using the same **Date** or **Date/Time** type, as a mismatch can prevent the filter from working as expected. If possible, please also let us know: * Which data source you're using (SQL Server, Fabric Warehouse, etc.). * Whether you're using Import or DirectQuery mode. * The complete M query or a sample of it. These details will help identify the exact cause and suggest the correct solution.

SHIV_SHANKAR's avatar
SHIV_SHANKAR
New Member
2 months ago

Hi,

Here are the details:

  • Source: Oracle (DirectQuery)
  • Parameter type: Date/Time (matches column type)
  • Slicer: Dropdown/List
  • And this is the M code 

    "let
    AsOf = DateTime.ToText(AsOfDate, "yyyy-MM-dd"),
    SQL =
    "SELECT *
    FROM TABLE(get_payoff_mapping_facility(
    DATE '" & AsOf & "',
    '" & P_DOSNUM_FILTER & "'
    ))",

    Source = Oracle.Database(ServerDetails,[Query=SQL])
    in
    Source"