Forum Discussion

Coelijoeli's avatar
Coelijoeli
Advocate I
10 years ago

Days between two dates columns

Hello community,   I'm building a dashboard with Power BI Desktop. I've connected a SQL server database which has two date fields:   [Transactiondate] [Closed]   What I want to do is get the ...
Need Help
MAPA's avatar
MAPA
Regular Visitor
9 years ago

Hello,

I've used your suggestion which seem to be good but something is wrong there.

Have you ever seen like this:

Start dateEnd dateNo of days
2016.12.092017.09.04269
2016.12.092017.09.01532
2016.12.092017.08.311855
2016.12.092017.08.10244
2016.12.092017.07.311170
2016.12.092017.07.13216
2016.12.092017.06.301015

 

When the end date is the last day of the month it gives wrong result. :(

 

Do you have any idea?

dramus's avatar
dramus
Continued Contributor
8 years ago

 

 

 

 

I can't reproduce your problem. Ar your columns defined as dates?