Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!

Reply
RonaldvdH
Post Patron
Post Patron

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
Anonymous
Not applicable

Hi,

Can you share your DAX please?

Thanks.

@Anonymous  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

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

Helpful resources

Announcements
April AMA free

Microsoft Fabric AMA Livestream

Join us Tuesday, April 09, 9:00 – 10:00 AM PST for a live, expert-led Q&A session on all things Microsoft Fabric!

March Fabric Community Update

Fabric Community Update - March 2024

Find out what's new and trending in the Fabric Community.