Forum Discussion
Days Between - Days Since DAX
However, the most recent "Days Between" data point will never be accurate since another injury has yet to occur.Read about COALESCE and TODAY()
Super UserHowever, the most recent "Days Between" data point will never be accurate since another injury has yet to occur.
Read about COALESCE and TODAY()
Thank you for your response! This did work. However, when I change the filters to show other category of injuries, the chart is not accurate at all. It seems the chart is only accuracte with one type of injury.
Would you have any idea to why this is? Everything is exactly the same other than the injury category filter.
- lbendlin
Please provide sample data that covers your issue or question completely, in a usable format (not as a screenshot).
Do not include sensitive information or anything not related to the issue or question.
If you are unsure how to upload data please refer to https://community.fabric.microsoft.com/t5/Community-Blog/How-to-provide-sample-data-in-the-Power-BI-Forum/ba-p/963216
Please show the expected outcome based on the sample data you provided.
Want faster answers? https://community.fabric.microsoft.com/t5/Desktop/How-to-Get-Your-Question-Answered-Quickly/m-p/1447523