Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
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!
Hi @powerEDCE ,
By my reserch, there is a similar thread for your reference: Power Query Apply Parameter - Microsoft Q&
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.
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.