Forum Discussion
Anonymous
6 years agoNot applicable
DiffDate between two dates with where or IF condition
Hi DAX Community! Im new with the Power BI Report Builder, and I'm trying to do following: I am building a Defect Report which is finished to most part, now i want to implement a lead-time ta...
- Anonymous6 years ago
I solved my Problem by a workaround. I created a new column with sql which gives me the dates of the specific statuschanges and then i said DateDiff(CreatedDate, InAnalysisDate, Day) and its working now like that.
Then i Also created a Measure which give me an average time of all 21k issues to get 1Value
Anonymous
6 years agoNot applicable
I solved my Problem by a workaround. I created a new column with sql which gives me the dates of the specific statuschanges and then i said DateDiff(CreatedDate, InAnalysisDate, Day) and its working now like that.
Then i Also created a Measure which give me an average time of all 21k issues to get 1Value