How to fix Mdxscript(model) (6,68) calculation error in measure 'Sheetname': Function 'Dateadd' only works with contiguous data selections:

Question

Hi team,

I have encountered the below error message when refreshing the data.

The query did not run or the Data Model could not be accessed. Here's the error message we got:

Mdxscript(model) (6,68) calculation error in measure 'Sheet name': Function 'Dateadd' only works with contiguous data selections:

This master excel file is connected with 3 different excel files containing the raw data through the power query.

Could you please let me know how to resolve this issue? Your feedback will be greatly appreciated.

Best,

Answer 1

Hi,

Based on the error message "Function 'Dateadd' only works with contiguous data selections", it seems the function is incorret.

I suggest you refer to this function article:

https://learn.microsoft.com/en-us/dax/dateadd-function-dax

Just checking in to see if the information was helpful. Please let us know if you would like further assistance.

---

If the response is helpful, please click "Accept Answer" and upvote it.

Note: Please follow the steps in our documentation to enable e-mail notifications if you want to receive the related email notification for this thread.