Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
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?
Solved! Go to 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
Regards
Miguel Félix
Proud to be a Super User!
Check out my blog: Power BI em PortuguêsHi @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
Yes,MFelix's suggestion worked!!
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
Proud to be a Super User!
Check out my blog: Power BI em PortuguêsYes, It worked. Thanks!!
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
116 | |
104 | |
77 | |
71 | |
50 |
User | Count |
---|---|
146 | |
107 | |
106 | |
89 | |
65 |