The ultimate Fabric, Power BI, SQL, and AI community-led learning event. Save €200 with code FABCOMM.
Get registeredEnhance your career with this limited time 50% discount on Fabric and Power BI exams. Ends August 31st. Request your voucher.
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 |
---|---|
26 | |
12 | |
8 | |
8 | |
5 |
User | Count |
---|---|
30 | |
14 | |
12 | |
12 | |
7 |