Earn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.
I have been trying to show days between injury dates. I was able to accomplish this task. However, the most recent "Days Between" data point will never be accurate since another injury has yet to occur.
I have also created a "Days Since" measure to show how many days since the last injury.
My question is, how can I have a measure show days between injury unless it is the most recent injury(unable to show days between). So, I am needing a days between previous injuries along with a days since count for the most recent datapoint.
Below are the current dax formulas for each measure:
Solved! Go to Solution.
However, the most recent "Days Between" data point will never be accurate since another injury has yet to occur.
Read about COALESCE and TODAY()
However, 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.
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-...
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/1447...
User | Count |
---|---|
54 | |
22 | |
19 | |
16 | |
11 |
User | Count |
---|---|
81 | |
55 | |
39 | |
20 | |
12 |