Power BI is turning 10, and we’re marking the occasion with a special community challenge. Use your creativity to tell a story, uncover trends, or highlight something unexpected.
Get startedJoin us for an expert-led overview of the tools and concepts you'll need to become a Certified Power BI Data Analyst and pass exam PL-300. Register now.
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.
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.
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.
This is your chance to engage directly with the engineering team behind Fabric and Power BI. Share your experiences and shape the future.
Check out the June 2025 Power BI update to learn about new features.
User | Count |
---|---|
10 | |
9 | |
8 | |
7 | |
6 |
User | Count |
---|---|
14 | |
13 | |
11 | |
9 | |
8 |