Forum Discussion
Solved
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 hour...
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 ChangIf 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.