Forum Discussion

RonaldvdH's avatar
RonaldvdH
Icon for Post Patron rankPost Patron
7 years ago

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 pas...
Need Help
Anonymous's avatar
Anonymous
Not applicable
7 years ago

Hi,

Can you share your DAX please?

Thanks.

RonaldvdH's avatar
RonaldvdH
Icon for Post Patron rankPost Patron
7 years ago

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
    ))
  • v-eachen-msft's avatar
    v-eachen-msft
    Icon for Community Support rankCommunity Support
    7 years ago

    Hi RonaldvdH ,

     

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

     

    • RonaldvdH's avatar
      RonaldvdH
      Icon for Post Patron rankPost Patron
      7 years ago

      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 ?

      • v-eachen-msft's avatar
        v-eachen-msft
        Icon for Community Support rankCommunity Support
        7 years ago

        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.