Help me understand an error in a formula

Question

Goodevening,&nbsp;One of my formula's (which always worked) just returned an error which i can't explaing.Roughly translated it states that:&nbsp;A startdate in the function 'Calendar' may not be past the enddate&nbsp;I thought someone entered a date which was before (or past) the dates in my 'date' table but even when ive extended the range the error still stayed and im not sure how to correct it.&nbsp;Can someone help me please ?

ronaldvdh · Answer

Anonymous&nbsp; sure thing, should have added it in the first place :)&nbsp;Doorlooptijd Schades in Werkdagen = VAR YourDate = if(IsBlank([afgehandeld]); TODAY(); [afgehandeld])RETURNCOUNTROWS( &nbsp;&nbsp;&nbsp;&nbsp;FILTER(&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;ADDCOLUMNS(&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;CALENDAR(&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;[binnengekomen]; &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;YourDate&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;); &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;"DayofWeek"; &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;WEEKDAY(&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;[Date];&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;2&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;)&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;); &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;[DayofWeek] &lt;&gt; 6 &amp;&amp; [DayofWeek] &lt;&gt; 7&nbsp;&nbsp;&nbsp;&nbsp;))

anonymous · Answer

Hi,Can you share your DAX please?Thanks.

v-eachen-msft · Answer

Hi&nbsp;RonaldvdH&nbsp;,
&nbsp;
You could use a card visual to show the [binnengekomen] and check if it is correct.
&nbsp;

ronaldvdh · Answer

v-eachen-msft&nbsp; the first date for [binnengekomen] is 01-03-2019 and the first date in de 'Date' table is 01-01-2019 so that should be correct right ?

v-eachen-msft · Answer

Hi&nbsp;RonaldvdH&nbsp;,
&nbsp;
Sorry, I didn't make it clear.
Firstly, you need a new measure to show "YourDate" directly.
Measure = 
if(IsBlank([afgehandeld]); TODAY(); [afgehandeld])
Then you could use two card visuals to show [binnengekomen] and [Measure]. Check if the start date is past the end date.
&nbsp;

Forum Discussion

Help me understand an error in a formula

9 Replies

Related content

Understanding Lineage View

If formula

Understanding Report

Understanding Capacity Units (CU)

Understanding Dimensional Modeling