Forum Discussion

powerEDCE's avatar
powerEDCE
Frequent Visitor
4 years ago

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

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!