Forum Discussion
Help With DAX calculated column finding the earliest Date?
- 10 years ago
Thank You Jahida, That looks like it worked. Here is a copy of the me imputting this into my dashboard.
- 10 years ago
No problem. You killed the pronounciation the first time, then corrected yourself wrong haha.
- 10 years ago
I'm not an expert on this (many other people on this forum are experts by comparison), but here's my take:
DAX I find much easier to write. It's flexible, in my experience executes quickly on refresh, and if you use measures it can be dynamic.
M is a bit harder to write, for me at least. However, any processing you do in M, although it may not necessarily be faster, is better for the size of your file because 1) you can filter out unnecessary information before it loads and 2) columns created in M or brought in straight from the source are stored more efficiently than ones created in DAX (I just learned that yesterday). Also, M can be faster by pushing calculations back into the database at times. This, in my experience, is very inconsistent, but at times a great speedup.
Basically for a user just starting up, I would recommend doing filtering in M and nearly everything else in DAX, unless your dataset is absolutely massive and size is a massive concern.
Many people in the forum will protest that anything other than a Date table and calculated measures in DAX is bad style, at some point it does come down to personal preference and an ease of use vs. efficiency trade-off.
I'm sure there is a solution to this problem in M. It would take me a while to write though since I'm much more comfortable in DAX.
Thank You Jahida, That looks like it worked. Here is a copy of the me imputting this into my dashboard.
No problem. You killed the pronounciation the first time, then corrected yourself wrong haha.
- GEN3Electric10 years agoRegular Visitor
I will be sure to review the video and get the name right in the future. Thank you again.