Forum Discussion
Compare two dates in different lines for same ID
Hi Krlos5411
Would a measure like this work?
Days from Created to Approval = VAR _CurrStatus = SELECTEDVALUE('Table'[Status]) VAR _Create = CALCULATE( MIN('Table'[Due Date]), ALL('Table'[Due Date]), 'Table'[Status] = "CREATE" ) VAR _Approval = CALCULATE( MAX('Table'[Due Date]), ALL('Table'[Due Date]), 'Table'[Status] = "APPROVAL" ) VAR _Result = IF( NOT ISBLANK(_Approval) && _CurrStatus = "APPROVAL", DATEDIFF(_Create, _Approval, DAY) ) RETURN _ResultLet me know if you have any questions.
Days from Created to Approval.pbix
Super UserHi Krlos5411
The DAX I supplied is for a measure. Exit from Power Query and create a new measure.
Also, take a look at my pbix.
It works. Thank you.
As I have the calculation of the days in a table and I need to have all the measures showed so the calculation can be done, do you know hoy can I have an average of those days in a separate card? For example, this average is 2.19 and I want this in a separate card.
- gmsamborn
Hi Krlos5411
For use in a card would the following measure help?
Measure = AVERAGEX( 'Table', [Days from Created to Approval] )I got it in blank. I saw you example pbix, and it works but I think that is because you only are considering one ticket. I have several tickets with the calculation from start to end process.