count number of dates

[giorgilomidze]

I have data in which first operation was at 28th of octobar 2017 and since then table is working. so i have data in 2017 and in 2018. i need to count number of days since 28/10/2017.

i used several functions: 

ALLNOBLANKROW(PRXGetAllRequestsView[1.1 მოთხოვნის შექმნის დრო +4].[Date]) -   gives me error VALUES(PRXGetAllRequestsView[1.1 მოთხოვნის შექმნის დრო +4].[Date]) - gives me error

COUNTX(PRXGetRequestTable,[მოთხოვნის შექმნის დრო 1.1 +4].[Date]<>BLANK()) - gives me error DISTINCTCOUNT(PRXGetRequestTable[მოთხოვნის შექმნის დრო 1.1 +4].[Date]) - gives me 730 (2*365)

and several others give me 730 as well.

why is it counting all the days from 01/01/2017 till 31/12/2018?

I even tried creating table, and new column with just dates but both of them are showing me 730.

how else can i count days of operational periods?

[danextian · Accepted solution]

 Hi @giorgilomidze,

Are the dates in the same column or two different columns?

If it is the latter, you can simply do End Date - Start Date or DATEDIFF( StartDate, EndDate, DAY). If it is not the case, the please post a sample data.