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.
I am new to DAX - I'm creating a new measure to measure the time between 2 dates. In using DATEDIFF its only showing me other calculated measures and not the other date fields to select from. Why won't it show me the DATE fields I have data in?
Solved! Go to Solution.
Hi , @Anonymous
Here is a demo :
create a measure as below:
Date Dif2 = DATEDIFF(MAX(A[Goal Date]),MAX(A[Finish]),DAY)
Best Regards,
Community Support Team _ Eason
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Hi , @Anonymous
Here is a demo :
create a measure as below:
Date Dif2 = DATEDIFF(MAX(A[Goal Date]),MAX(A[Finish]),DAY)
Best Regards,
Community Support Team _ Eason
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
In measures, you have to refer to columns using an aggregation like MAX, MIN, SUM, etc.
If the are on the same table you can use datediff in a column. If they are on a different table or in you want measure then it need context.
And the pbix file: https://www.dropbox.com/s/y47ah38sr157l7t/Order_delivery_date_diff.pbix?dl=0
look for 4 ways
@Anonymous , does it helped. Do you need more information.
Hi @Anonymous
if your start and end dates to datediff calculate placed in the same row you should use a New Column, not measure
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 |
---|---|
111 | |
100 | |
80 | |
64 | |
57 |
User | Count |
---|---|
146 | |
110 | |
93 | |
84 | |
67 |