topic Re: Date Slicer with starting with the Currentdate and then show data for the next 4 months in DAX Commands and Tips

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

westman — Fri, 21 Oct 2022 19:37:54 GMT

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

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

amitchandak — Sat, 22 Oct 2022 04:20:39 GMT

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))

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-654f26e27304

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

westman — Mon, 24 Oct 2022 16:41:32 GMT

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