- Subscribe to RSS Feed
- Mark Topic as New
- Mark Topic as Read
- Float this Topic for Current User
- Bookmark
- Subscribe
- Printer Friendly Page
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
DAX errors after refreshing data
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.
Solved! Go to Solution.
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
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.
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
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.

Helpful resources
Subject | Author | Posted | |
---|---|---|---|
05-23-2024 09:19 AM | |||
11-29-2023 02:26 AM | |||
04-22-2024 02:12 AM | |||
05-20-2024 02:36 AM | |||
01-17-2023 12:36 AM |