Today()-30 day record

[Anonymous]

Hi,

Getting error while calculating today-30 day data.

It is working fine but when i select calendar filter for particular month it is not working.

For eg. in November month i dont have 14th and 15th day records and when i select november month i am getting this error.

It looks like i dont have continuos date thats why i am getting this error?Any idea? Any solution?

[v-juanli-msft]

Hi @Anonymous

MFelix's suggestion should be helpful.

If it not suit your scenario, could you show me an example of your scenario?

Best Regards

Maggie

[Anonymous]

Yes,MFelix's suggestion worked!!

[MFelix · Accepted solution]

Hi @Anonymous,

To use the DATEADD as the error says you need contiguos data, I would create a dimension Dates table and relate that with the date on your table and use that also for calculating the Dates filters.

Should work, if you need any assistance please share a sample of data or copy of PBIX file.

Regards,

MFelix

[Anonymous]

Yes, It worked. Thanks!!