Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
Hi,
I have two measures with calculated date values.
Measure 1:
How can i create another measure to find number of days between them?
Solved! Go to Solution.
Hey @Sdhn420 ,
returning the number of days between two dates is quite straight forward, as dates are stored as decimals internally. For this reason the below sample returns 15, you might have to consider adding 1 if you want to count the start date as well.
Days between dates =
var measure1 = DATE( 2021 , 6 , 2 )
var measure2 = DATE( 2021 , 6 , 17 )
return
INT( measure2 - measure1 )
Hopefully, this provides what you are looking for.
Regards,
Tom
Thank you so much! This is exactly what I was looking for!
Hey @Sdhn420 ,
returning the number of days between two dates is quite straight forward, as dates are stored as decimals internally. For this reason the below sample returns 15, you might have to consider adding 1 if you want to count the start date as well.
Days between dates =
var measure1 = DATE( 2021 , 6 , 2 )
var measure2 = DATE( 2021 , 6 , 17 )
return
INT( measure2 - measure1 )
Hopefully, this provides what you are looking for.
Regards,
Tom
Thank you so much! This is exactly what I was looking for!
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
114 | |
99 | |
82 | |
70 | |
60 |
User | Count |
---|---|
149 | |
114 | |
107 | |
89 | |
67 |