How do I do an end date in Power Query?

[Anonymous]

Hello! Here is my power query. However, I am unsure how to do a date range from 11/21/2022  to just a specific date (like 2/27/2023). Can I change this line in my power query to do that?

{Cube.ApplyParameter, "DateRange", {#date(2022, 11, 21), Date.AddDays(DateTime.Date(DateTime.LocalNow()),-4)}},

[ppm1]

Try this instead

{Cube.ApplyParameter, "DateRange", {#date(2022, 11, 21), #date(2023,2,27)}},

Pat