SQLBits 2024
Power BI - Creating a M-agical Date Table
This session will go through a variety of ways to utilize the M language to create and manipulate columns. We will be creating a table from scratch and adding the hammer of M to the toolbelt of fellow report designers. Beginners welcome!
By the end of this session, attendees will have a deeper understanding of how to manipulate M code in Power BI through the process of building a highly customized date table.
Many times Power BI developers get caught between DAX and SQL when they need the flexibility of DAX but the performance benefits of SQL, which leaves them in the land of M. Similar to Oz, M is full of magic that is more attainable than meets the eye. This session demystifies the functionality of Power Query and covers when Power Query may be the best option.
Many times Power BI developers get caught between DAX and SQL when they need the flexibility of DAX but the performance benefits of SQL, which leaves them in the land of M. Similar to Oz, M is full of magic that is more attainable than meets the eye. This session demystifies the functionality of Power Query and covers when Power Query may be the best option.