date diff

3 Topics

Average days in Phase
I have the tablex with the columns date (daily), name_id and phases. Each row corresponds a day, name_id and phase. I would like to create a measure that counts how many days on average a name_id stays in a phase (important to calculate just for the ones who have more than one phase registered). In the sample bellow it should calculated for name_id "d567" from the phase "Middle" until the first day "Premium" appears. Thank you
Anonymous
3 years ago Place DAX Commands and Tips
1.6KViews
0likes
5Comments
MIN DATE FUNCTION
Hi Everyone, Here I have Stuck with MIN DATE function from FROMM_DATE ; from mx APBDR we have 3 Same Values of NSP10 and 3 Different Values in FROM_DATE. I have need only 11-May-20 from that which is MINIMUM of Nsp10.
Solved
SIBI1998
4 years ago Place DAX Commands and Tips
951Views
0likes
3Comments
Dax Commands with Date vs Days
I am trying to get the Number of Days between two Dates, then if <= 30, I want the Original Amount to show in the New Current Column. If >= 30 AND <=60, then the Original Amount show in the New 31-60 Column. I'm not getting any DAX error using the below info, but it's showing the Original Amount in both Columns. What am I doing wrong? Any help would be appreciated. New Current = IF(DATEDIFF([Invoice Date].[Date], [New Date Paid Off].[Date] <= 30, DAY), Exceptions[Original Amount],0) New 31-60 = IF(DATEDIFF([Invoice Date].[Day] >= 31, [New Date Paid Off].[Day] <= 60,DAY), Exceptions[Original Amount],0)
Solved
ktipton
4 years ago Place DAX Commands and Tips
1.7KViews
0likes
5Comments