DAX Fridays! #85: Difference between dates in the same column скачать в хорошем качестве

DAX Fridays! #85: Difference between dates in the same column

Do you know how to calculate the difference between dates when both are in the same column? One example of when this is needed is when you are working with subscription based services. If you want to calculate how many dates go between users changing subscriptions, this DAX measure will help you. To do this we will use DATEDIFF, ALLEXCEPT and EARLIER. and here is a link to Chris Webb trick : https://blog.crossjoin.co.uk/2018/06/... Enjoy. Link to the file here: https://curbal.com/blog/glossary/date... (example 3) Get Northwind Dataset:    • Northwind data source: A great online sour...   Link to DAX Fridays survey: http://bit.ly/2MMM4KK Looking for a download file? Go to our Download Center: https://curbal.com/donwload-center SUBSCRIBE to learn more about Power and Excel BI!    / @curbalen   Our PLAYLISTS: Join our DAX Fridays! Series: https://goo.gl/FtUWUX Power BI dashboards for beginners: https://goo.gl/9YzyDP Power BI Tips & Tricks: https://goo.gl/H6kUbP Power Bi and Google Analytics: https://goo.gl/ZNsY8l ABOUT CURBAL: Website: http://www.curbal.com Contact us: http://www.curbal.com/contact ************ ************ QUESTIONS? COMMENTS? SUGGESTIONS? You’ll find me here: ► Twitter: @curbalen, @ruthpozuelo ► Google +: https://goo.gl/rvIBDP ► Facebook: https://goo.gl/bME2sB #DAXFRIDAYS #CURBAL #DAX #POWERBI #MVP