Learn how to use the function EARLIER in DAX/ Powerpivot.
Link to pbix and excel file: curbal.com/blog/glossary/earlier-dax
EARLIER is mostly used in the context of calculated columns.
The performance of EARLIER might be slow because it theoretically, it might have to perform a number of operations that is close to the total number of rows (in the column) times the same number (depending on the syntax of the expression). For example if you have 10 rows in the column, approximately a 100 operations could be required; if you have 100 rows then close to 10,000 operations might be performed.
Source: msdn.microsoft.com/en-us/library/ee634551.aspx
PREVIOUS VIDEO: kzitem.info/news/bejne/joWix2ZsbZR8i6A
NEXT VIDEO: -
Looking for a download file? Go to our Download Center: curbal.com/donwload-center
SUBSCRIBE to learn more about Power and Excel BI!
kzitem.info/rock/J7UhloHSA4wAqPzyi6TOkw
Our PLAYLISTS:
- Join our DAX Fridays! Series: goo.gl/FtUWUX
- Power BI dashboards for beginners: goo.gl/9YzyDP
- Power BI Tips & Tricks: goo.gl/H6kUbP
- Power Bi and Google Analytics: goo.gl/ZNsY8l
ABOUT CURBAL:
Website: www.curbal.com
Contact us: www.curbal.com/contact
QUESTIONS? COMMENTS? SUGGESTIONS? You’ll find me here:
► Twitter: @curbalen, @ruthpozuelo
► Google +: goo.gl/rvIBDP
► Facebook: goo.gl/bME2sB
#daxfridays #curbal #SUBSCRIBE
► Linkedin: goo.gl/3VW6Ky
Негізгі бет DAX Fridays! #13: EARLIER
Пікірлер: 182