Dynamic Format Strings for Measures27th April 2023New feature alert! The April 2023 update has introduced a game-changing feature: Dynamic Format Strings for Measures. With this new addition, you can create format strings using DAX expressions to make your reports even more adaptable and user...
Why Do I Need a Date Table in My Data Model?26th September 2022The following is an extract from Alison's book 'Up and Running with DAX for Power BI' Have you ever wanted to compare sales for the current month...
Filtering Using DAX Measures17th August 2022A question that we are often asked is this; can you put a measure into a Slicer? The answer of course is no, only columns from tables can be populated...-
7 Secrets to Learning DAX22nd July 2022Most people attempt to learn DAX like they learned Excel. They think they can just get to grips with a few formulas, perhaps even nesting a few...
Context Transition: Where the Row Context Becomes a Filter Context24th August 2021“Nothing in life that’s worth anything is easy.” Barack Obama. And we could also say that nothing in DAX that’s worth anything is easy! Certainly the...
Why You Should Never Assume Your DAX Code is Correct; Taking a Closer Look at Bi-Directional Filtering26th May 2021I recently listened to a thought-provoking blog from Alberto Ferrari ( https://ssbi-blog.de/podcast/experts-talk/chat-with-alberto-ferrari/ ). In it...
Where do I make data transformations in Power BI ? Roche’s Maxim21st March 2021When we’re Training on Power BI a frequent question we get is “I need to make changes to my data for reporting, where is the best place to do that, in...
Blog
As Microsoft software evolves and new opportunities to enhance your data visualisation and integration evolve through Power BI, we like to keep you up to date. Our blog not only looks at new developments but shares consultancy news and training opportunities. Sign up to our blog to stay in touch.
