Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!
Hi and thanks for reading this.
I am trying to find a "correct" calender calculations for Age between 2 dates.
From what i can see "DATEDIFF('Table'[monthh];'Table'[Today];MONTH)" only changes Age when month changes , not taking the amount of days .
As you can see on the picture in yellow 69 days is still Age 2 but when we change month to 201912 it changes to Age 3
Is there any other way to calculate AGE between 2 dates ?
Solved! Go to Solution.
Not sure if i understand correctly but you want the difference in days? In that case you can use this code:
DATEDIFF('Table'[monthh];'Table'[Today];DAY)
As you can see the last part of a DATEDIFF function is the interval.
Quality over Quantity
What it should have displayed?
Hi @EricHulshof and @amitchandak
I might run into a mind mine and did not think correctly
i think i will solve my "problem" with the measure Erichulshof posted
Not sure if i understand correctly but you want the difference in days? In that case you can use this code:
DATEDIFF('Table'[monthh];'Table'[Today];DAY)
As you can see the last part of a DATEDIFF function is the interval.
Quality over Quantity
User | Count |
---|---|
128 | |
108 | |
99 | |
65 | |
62 |
User | Count |
---|---|
136 | |
113 | |
102 | |
71 | |
60 |