Relative Date Slicer - Get Next Month

DAX DAX Calculations
1

Given I have a Relative Date Slicer that could have any range - i,e Last 4 Months or Last 3 Weeks

and I have a Measure that calculates Total Bookings for the selected date range

How do I calculate the Total Bookings for just the Next Month
i.e. if the Slicer is last 3 Weeks which equals a Date Range or 02-11-2023 to 22-11-2023 how do I get Total Bookings for 01-12-2023 to 31-12-2023

Assume a Date Dimension is joined to a Fact containing a Measure Total Bookings - the grain of the Fact table is Day

2

See if it helps
Reserva.pbix (32.0 KB)

Date Range = 01-01-2023 to 10-01-2023
Total Bookings = 01-02-2023 to 10-02-2023

Sem título

3

Hi Vilmar

Thanks for that - I think I new that (well most of it) - I had forgotten the ALL bit

Much appreciated