cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Anonymous
Not applicable

Today()-30 day record

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?

 

 

Screenshot_2.png

1 ACCEPTED SOLUTION
MFelix
Super User III
Super User III

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


Regards

Miguel Félix


Did I answer your question? Mark my post as a solution!

Proud to be a Super User!

Check out my blog: Power BI em Português



View solution in original post

4 REPLIES 4
v-juanli-msft
Community Support
Community Support

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
Not applicable

Yes,MFelix's suggestion worked!!

MFelix
Super User III
Super User III

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


Regards

Miguel Félix


Did I answer your question? Mark my post as a solution!

Proud to be a Super User!

Check out my blog: Power BI em Português



View solution in original post

Anonymous
Not applicable

Yes, It worked. Thanks!!

Helpful resources

Announcements
PBI User Groups

Welcome to the User Group Public Preview

Check out new user group experience and if you are a leader please create your group

April Update

Check it Out!

Click here to read more about the April 2021 Updates!

secondImage

The largest Power BI virtual conference

100+ sessions, 100+ speakers, Product managers, MVPs, and experts. All about Power BI. Attend online or watch the recordings.

secondImage

Experience what’s next for Power BI

See the latest Power BI innovations, updates, and demos from the Microsoft Business Applications Launch Event.