cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Helper IV
Helper IV

Help me understand an error in a formula

Goodevening,

 

One of my formula's (which always worked) just returned an error which i can't explaing.

Roughly translated it states that:

 

A startdate in the function 'Calendar' may not be past the enddate

 

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.

 

Can someone help me please ?

9 REPLIES 9
Solution Supplier
Solution Supplier

Hi,

Can you share your DAX please?

Thanks.

@vaibhavdesai  sure thing, should have added it in the first place 🙂

 

Doorlooptijd Schades in Werkdagen = VAR YourDate = if(IsBlank([afgehandeld]); TODAY(); [afgehandeld])
RETURN
COUNTROWS(
    FILTER(
        ADDCOLUMNS(
            CALENDAR(
                [binnengekomen];
                YourDate
            );
            "DayofWeek";
            WEEKDAY(
                [Date];
                2
            )
        );
        [DayofWeek] <> 6 && [DayofWeek] <> 7
    ))

Hi @RonaldvdH ,

 

You could use a card visual to show the [binnengekomen] and check if it is correct.

 

Community Support Team _ Eads
If this post helps, then please consider Accept it as the solution to help the other members find it.

@v-eachen-msft  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 ?

Hi @RonaldvdH ,

 

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.

 

Community Support Team _ Eads
If this post helps, then please consider Accept it as the solution to help the other members find it.

@v-eachen-msft the measure doesn't work and returns the error that the value for the column 'afgehandeld' cannot be determined. The colum 'Afgehandeld'doesn't excist of there is not a current row for a colum with the name 'afgehandeld'.

 

I checked both criteria and both are wrong but i can't find the problem

@v-eachen-msft  you have any ideas ?

The formula looks fairly straight forward but still returns an error

@v-shex-msft do you have any ideas about this question, its been quiet for a while

@vaibhavdesai and @v-eachen-msft can't either of you help me with this formula ?

Helpful resources

Announcements
November Update

Check it Out!

Click here to read more about the November 2020 Updates!

Community Conference

Power Platform Community Conference

Check out the on demand sessions that are available now!

secondImage

Power Platform October Community Highlights

Check out the top community contributors across all of the communities

secondImage

Create an end-to-end data and analytics solution

Learn how Power BI works with the latest Azure data and analytics innovations at the digital event with Microsoft CEO Satya Nadella.

Top Solution Authors
Top Kudoed Authors