Count number of days
=SUM(History[Evaluation])/NUMBER(DATE(TODAY())-DATE(“1/7/2019”))
SUM(History[Evaluation])=141 NUMBER(DATE(TODAY())-DATE(“1/7/2019”))=0 I want to get ‘29’ as counting the days from 1/7/2019 but it keeps giving me ‘0’
How can I get ‘29’?
User | Count |
---|---|
40 | |
34 | |
28 | |
23 | |
17 |