Forum Discussion
Solved
Calculate date difference without aggregating using DAX
Hi All, I have a requirement to calculate the difference between two dates. Please find sample data below: Protocol Start Date Status End Date A 9/26/2022 In-Progress 11/20/2022 A...
Simplest dax can be as follows.
SUMX(SUMMARIZE('Table','Table'[protocol],'Table'[start],'Table'[end],"datediff",DATEDIFF('Table'[start],'Table'[end],DAY)),[datediff]).
This will give you was u required.
Summarize is good approach to avoid certain columns which creates aggregation or double dip on values
Simplest dax can be as follows.
SUMX(SUMMARIZE('Table','Table'[protocol],'Table'[start],'Table'[end],"datediff",DATEDIFF('Table'[start],'Table'[end],DAY)),[datediff]).
This will give you was u required.
Summarize is good approach to avoid certain columns which creates aggregation or double dip on values
Anonymous - thank you for the response. This solution worked.
You are most welcome:-)