Forum Discussion
Power BI - cases statistics
Community SupportHi _Roberto_ ,
After checking the visual, we found the error reason in my formula, when using weeknumber, it contains same week in multi years, can you put a filter year = 2018 and see if the formula can return the expected result?
Edited, Sorry I did not see the selected year in the origin post, kindly share your sample data and expected result to me if you don't have any Confidential Information. Please do not use any real data. Please upload your files to One Drive and share the link here.
Best regards,
Community Support Team _ Dong Li
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
v-lid-msft thank you again for your support.
I am sorry for the late reply, but maybe I found the issue.
As I said data are retreived from a direct query from CRM dynamics database.
In CRM I configured a workflow that is filling the column "closedon" by performing a copy of the value of "modifiedon" when the status reason of the a ticket is changed in "closed".
So, I think that is matter of timing because probably the workflow is not syncronizing data in short time.
I found this issue by performing an export of CRM data in the excel file (sorry if I didn't sent yet). Using the excel file all charts are correct.
- v-lid-msft
Hi _Roberto_ ,
So when the measure run, the enddate may be blank? If the enddate will be filled several times one day, do you have a logic about how to deal with this empty date? We can modify the formula to meet your new logic.
Best regards,
Community Support Team _ Dong Li
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.