SAP BW - Cube Apply Parameter - All dates smaller or equal than a defined date

[powerEDCE]

Dear all,

I want to connect Power BI to an SAP data base. For a certain table, in the data selection view I can chose to get data for a defined reporting date, e.g. reporting date = 30.03.2022.

However, I would like to filter to something like reporting date <= 30.03.2022. Of course I can filter later on in the transformation view but I want to let the SAP database compute as much as possible natively. So I tried to change the PowerQuery code of the source selection:

Here is the relevant snippet:

= Cube.Transform(TableXYZ,
        {
            {Cube.ApplyParameter, "OFFEN_ZUM_STICHTAG", {#date(2022, 5, 2)}},

I would like to have all data smaller or equal than 02.05.2022 - how do I need to change above query to achieve that?

Thanks in advance!

[v-yanjiang-msft]

Hi @powerEDCE ,

By my reserch, there is a similar thread for your reference:  Power Query Apply Parameter - Microsoft Q&amp

Take Table.SelectRows function have a try.

Best Regards,
Community Support Team _ kalyj

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