Edate Dax

Question

Hi there,I ve tried to create a comming due Dax for incomming goods control. This works great since edate works with months:&nbsp;Comming Due WEK = CALCULATE(COUNT('Wareneingang'[Status]);CONTAINSSTRING('Wareneingang'[TheoretischesFreigabedatum] &lt; EDATE(TODAY();1);'Wareneingang'[TheoretischesFreigabedatum] &gt; TODAY()))&nbsp;This gives me all comming dues within the next 30 days.&nbsp;Now I want to have the same query instead with 30days with 4 days.&nbsp;Theoretically u can calculate how month are 4 days in decimal (0.13333) but this doesnt work.&nbsp;Any ideas?

anonymous · Answer

Hi&nbsp;Yarisch77&nbsp;,&nbsp;&nbsp;You can use Today()-4 , in this case. Pls check and let me know.&nbsp;Regards,HNDid I answer your question? Mark my post as a solution! Appreciate with a Kudos!! (Click the Thumbs Up Button)

anonymous · Answer

Hi&nbsp;Yarisch77&nbsp;,&nbsp;&nbsp;CALCULATE(COUNT('Wareneingang'[Status]);CONTAINSSTRING('Wareneingang'[TheoretischesFreigabedatum] &lt; TODAY()-4 ;'Wareneingang'[TheoretischesFreigabedatum] &gt; TODAY()))&nbsp;Regards,Harsh NathaniDid I answer your question? Mark my post as a solution! Appreciate with a Kudos!! (Click the Thumbs Up Button)&nbsp;

lbendlin · Answer

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)

Forum Discussion

Edate Dax

Related content

DATEADD and EDATE

EDATE for days or weeks

Dax

DAX Formula Help

DAX