Nikola Ilic continues a series on getting ready for the DP-600 exam:
If you’re coming from the SQL world, you might have already heard about window functions. However, window functions are relatively new enhancement in the DAX language. Similar to SQL, they aim to provide the possibility to calculate specific expressions over a sorted and partitioned set of rows.
Read on to learn about three window functions in DAX, followed by a discussion of information functions and what they do.