No correct data in column dateadd

[Anonymous]

Hello,

I tried to use the Dateadd function but on some row I get no dates. Can you help me to find the problem?

This is the dax I used to calculate the previous month:

Vervaldatum opzegtermijn = DATEADD(Contracten[einddatum];-1;MONTH)

Any ideas?

[v-xicai]

Hi  @Anonymous  ,

Does that make sense? If so, kindly mark the proper reply as a solution to help others having the similar issue and close the case. If not,  let me know and I'll try to help you further.

Best regards

Amy

[v-xicai · Accepted solution]

Hi @Anonymous ,

The DATEADD function requires contiguous date selections , while your date is intermittent.

To work around the issue, you can create a calendar table using DAX below.

Calendar = CALENDAR(MIN(Table1[End date]),MAX(Table1[End date]))  

Or

Calendar =CALENDARAUTO()

Then you can create column in your original table.

Column1= DATEADD(Calendar[Date],-1,MONTH)

Best Regards,

Amy

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

[amitchandak]

Please correct the date format. Below datatype, you have the format option. The date is in the DD-MM-YY format. That is not detected as date  yet in the model.

[Anonymous]

Hi,

The date format is on both columns the same. Still not all the fields have a date.