[need help] How to filter date from today~ +15 days

[YMANIEE]

Hi guys,

I need a help with a dax formula.

How can I filter dates from today~ +15 days?

I am a newbie and couldn't find the answer on the net...

Please help!

Thank you. 🙂

[Anonymous · Accepted solution]

Hi @YMANIEE ,

I have created a simple sample, please refer to my pbix file to see if it helps you.

Create a measure.

Measure =
VAR _today =
    TODAY ()
VAR _15days =
    TODAY () + 15
RETURN
    IF (
        MAX ( 'Table'[Date] ) >= _today
            && MAX ( 'Table'[Date] ) <= _15days,
        1,
        BLANK ()
    )

If I have misunderstood your meaning, please provide your pbix file without privacy information and more details with your desired output.

Best Regards
Community Support Team _ Polly

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

[MahyarTF]

Hi,

If you are looking for the code for restricted date in particular days, you could use DateAdd Dax statement (Put NumberofInterval : -15 and Interval : Day)

https://dax.guide/dateadd/

[PC2790]

Hey,

If you are looking to do some calculation taking into account 15 days, you can try this:

Measure = var _datetoday = TODAY()
var _dateafter15days = TODAY()+15
return
CALCULATE([Measure],FILTER('Table',DATESBETWEEN('Date'[Date],Datetoday,Date15days)))

[YMANIEE]

Thanks for the reply,

This is what I inputed but I am getting error.

I want to simply filter the dates in SAP_date column with dates from today to +15 days)
I am totally newbie, please help again.

Thank you so much!

--------------------

Replenishment Schedule = var datetoday = today()

var dateafter15days = today()+15

return

calculate(Replenishment schedule,filter(smo_incoming_po,datesbetween(smo_incoming_po[SAP_date],datetoday,dateafter15days)))

-------------------

[PC2790]

What is the purpose of filtering the dates? Are you looking to show it somewhere or filter your columns based on that?

[YMANIEE]

I want to just filter existing column.
This column contains data from today~ several months after, but i just need today +15 days data only.
This report refreshes everyday, and I cannot fix today's date.
I thought it was a simple filtering but I am struggling for couple of hours already lol

[PC2790]

You can make use of the Filter in Power Query by using the "In the Next"noption as sown below:

See if caters to your requirement