Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!
Hi,
I'm struggling to filter my measure within a time range.
I need to CALCULATE(COUNTROWS) of my 'Contact' whereby their 'contact[Diagnosis Date] is within the last year.
Any tips would be great!!
Ah actually I need to update it slightly! I need to capture the 'contact'[diagnoses date] in relation to 'book application'[sentdate]
I need to be able to quantify where the 'book application'[sent date] is within a year of the diagnoses date. Is that at all possible?
You should just be able to change the last date in the measure to 'book application'[sent date]
If I answered your question, please mark my post as solution
Appreciate your Kudos 👍
Worked perfectly thankyou!
No problem, happy to help 🙂
User | Count |
---|---|
128 | |
108 | |
100 | |
64 | |
62 |
User | Count |
---|---|
136 | |
113 | |
102 | |
71 | |
60 |