Forum Discussion

IF's avatar
IF
Icon for Post Prodigy rankPost Prodigy
2 years ago

Automatic date input

Hi, I get the data from SAP with the following format: let Source = SapBusinessWarehouse.Cubes(................), #"Added Items" = .......... { {Cube.ApplyParameter, "[!V000003]", {#date(2023, 9...
Need Help
Anonymous's avatar
Anonymous
Not applicable
2 years ago

Hi IF ,

Please try:

let
    Source = SapBusinessWarehouse.Cubes(................),
    Today = DateTime.Date(DateTime.LocalNow()),
    Yesterday = Date.AddDays(Today, -1),
    #"Added Items" = ..........
    { {Cube.ApplyParameter, "[!V000003]", {Yesterday, Today}}},
    ...
in
    ...

Best Regards,
Gao
Community Support Team

 

If there is any post helps, then please consider Accept it as the solution  to help the other members find it more quickly.
If I misunderstand your needs or you still have problems on it, please feel free to let us know. Thanks a lot!

How to get your questions answered quickly --  How to provide sample data in the Power BI Forum

  • IF's avatar
    IF
    Icon for Post Prodigy rankPost Prodigy
    2 years ago

    Hi Thanks for the help. I will test it with a friend after he is back from holiday next week.