Forum Discussion

Yarisch77's avatar
Yarisch77
Frequent Visitor
6 years ago

Edate Dax

Hi there,

I ve tried to create a comming due Dax for incomming goods control. This works great since edate works with months:

 

Comming Due WEK = CALCULATE(COUNT('Wareneingang'[Status]);CONTAINSSTRING('Wareneingang'[TheoretischesFreigabedatum] < EDATE(TODAY();1);'Wareneingang'[TheoretischesFreigabedatum] > TODAY()))
 
This gives me all comming dues within the next 30 days.
 
Now I want to have the same query instead with 30days with 4 days.
 
Theoretically u can calculate how month are 4 days in decimal (0.13333) but this doesnt work.
 
Any ideas?
DAX Query

3 Replies

  • Anonymous's avatar
    Anonymous
    Not applicable
    6 years ago

    Hi Yarisch77 ,

     

     

    You can use Today()-4 , in this case. Pls check and let me know.

     

    Regards,

    HN

    Did I answer your question? Mark my post as a solution! Appreciate with a Kudos!! (Click the Thumbs Up Button)

  • Anonymous's avatar
    Anonymous
    Not applicable
    6 years ago

    Hi Yarisch77 ,

     

     

    CALCULATE(COUNT('Wareneingang'[Status]);CONTAINSSTRING('Wareneingang'[TheoretischesFreigabedatum] < TODAY()-4 ;'Wareneingang'[TheoretischesFreigabedatum] > TODAY()))

     

    Regards,
    Harsh Nathani

    Did I answer your question? Mark my post as a solution! Appreciate with a Kudos!! (Click the Thumbs Up Button)

     

  • lbendlin's avatar
    lbendlin
    Icon for Super User rankSuper User
    6 years ago

    Note that EDATE is much more subtle than just adding/subtracting 30 days. It also gracefully handles missing dates, like when you say EDATE("2020-03-31",-1)