Hi there,
I need to get the days between two dates. The two dates are both measures.
I keep getting the error below, even if I swop the dates.
The formula I used is:
Solved! Go to Solution.
@Annemie19 , This should have work
AA Days diff = if([AA Last value date]< [AA Latest Actual date], DATEDIFF([AA Last value date], [AA Latest Actual date] ,DAY), DATEDIFF([AA Latest Actual date] ,[AA Last value date], DAY))
Proud to be a Super User!
@Annemie19 , This should have work
AA Days diff = if([AA Last value date]< [AA Latest Actual date], DATEDIFF([AA Last value date], [AA Latest Actual date] ,DAY), DATEDIFF([AA Latest Actual date] ,[AA Last value date], DAY))
Proud to be a Super User!
User | Count |
---|---|
41 | |
21 | |
9 | |
9 | |
7 |
User | Count |
---|---|
44 | |
22 | |
12 | |
11 | |
10 |