DAX errors after refreshing data

[Timovb]

I have a DAX formule that works perfectly fine, untill I refresh the data. In the dataset, there are open- and closedates for servicetickets. I need to calculate the leadtime using only business hours. I have created a DAX that does this just fine, but i'm working with data that is constantly renewed becease tickets keep coming in. therefore the closing date is sometimes not filled in yet, becease the ticket is still open. I want to refresh the data once a day, but it errors after i refresh. It says: "Arguments in GenerateSeries cannot be blank". I have already got it working again by removing all empty cells, but i also want the active leadtime for the tickets that are still on ''open''. How can i adjust the DAX? Or is there another way i can make the refresh work without adding extra steps like removing the empty cells?

Here is the dax: 

Its in dutch because im from the netherlands, so heres the translation for the green text in the following points

15: Each minute between start- and enddate

16: Filter weekends

17: time between workdays

20: Count every valid minute as 1

Please let me know if I provided enough information.

[v-tianyich-msft · Accepted solution]

Hi @Timovb ,

The main reason for this is that GENERATESERIES can't accept null values, perhaps you could try converting the output using SELECTCOLUMNS

Generating a series of numbers in DAX - SQLBI

Hope it helps!

Best regards,
Community Support Team_ Scott Chang

If this post helps then please consider Accept it as the solution to help the other members find it more quickly.