Date Slicer with starting with the Currentdate and then show data for the next 4 months

[westman]

Hello-

I am new to Power Bi forums, this is my first post.  I am still absorbing how to work with DAX, and the proper way to present my scenario.  I have a line chart that on its x-axis i have a date field, on the Y-axis i have a count of future orders and their sales amount.

I would like to have a slicer utuilizing the date table have a measure that upon opening or refreshing the report it will start with the current date and then have a range of showing the forwarding 4 months worth of data. Utimately, I would like it to be able to drill down to the day.  Please any resources i may follow up with to solve this.

Any reccomendations on how to format future inquires, please advise.

Thank you for your time

Drew

[westman]

Thank you for your assistance @amitchandak .  This measure does accomplish my main goal.  However, if i may, i also use a date range slicer shown in the picture attached.  Do you have insight or advice onhow to have the slicer read the current date in accordance with the measure you provided?

Thank you for your assistance. Very appreciated.

Drew

 

[amitchandak · Accepted solution]

@westman , next 4 month based on today

4 Months Today =
var _min =  today()
var _max = eomonth(today(),4)
return CALCULATE([Net], FILTER('Date','Date'[Date] >=_min && 'Date'[Date] <= _max))

or

next 4 Months Today =
var _min =  eomonth(today(),0) +1
var _max = eomonth(today(),4)
return CALCULATE([Net], FILTER('Date','Date'[Date] >=_min && 'Date'[Date] <= _max))

https://medium.com/chandakamit/cheat-sheet-power-bi-time-intelligence-formulas-using-today-654f26e27...