Skip to content

Kasper On BI

All about Power BI, Modelling, DAX and Microsoft BI

  • About me
  • Kasper On BI Podcast & YouTube
Kasper On BI
  • About me
  • Kasper On BI Podcast & YouTube

Category: Power BI

Posted on May 5, 2020May 6, 2020 Power BI

Setting up translations for datasets in Power BI premium

One request that comes up a lot is to be able to provide translations for the tables and columns of your model (especially here in... Read more

Posted on April 28, 2020April 28, 2020 Power BI

Debug Power BI aggregations with DAX Studio

A quick post today. Sometimes you will be mystified why your aggregations are not getting hit. There is no clear-cut answer to why. The best... Read more

Posted on April 24, 2020April 24, 2020 Power BI

How to change the dataset script in Power BI desktop

I recently on some internal email by the developers where they mentioned something, offhand, what I think is amazing :). It will allow you to... Read more

Posted on April 22, 2020August 6, 2020 Analysis Services DAX Power BI

Dynamic formatstrings with Calculation groups

One of the cool things of calculation groups is they cannot just be used to apply a calculation over your “base measure” but also apply... Read more

Posted on April 17, 2020April 20, 2020 Analysis Services DAX Power BI

Adding calculation groups to (A)AS or PBI Premium

I was playing around with calculation groups for a question. I found that adding a calculation group is not that straightforward as it should be,... Read more

Posted on February 13, 2020February 13, 2020 Power BI

Get the SQL Query used in DirectQuery mode

When you are optimizing your DirectQuery model and you have done all the optimizations on the model already, you might want to run the queries... Read more

Posted on January 13, 2020January 13, 2020 Power BI

5 reasons to use aggregations in Power BI

A lot has already been written on aggregations and it is one of the most exciting features of Power BI in a while. The guys... Read more

Posted on December 30, 2019December 30, 2019 Power BI

Power BI and the year 2019 in review

As the end of the year closes I was reminiscing on what a huge year it has been for Power BI. I work mostly with... Read more

Posts navigation

← 1 2 3 4 … 7 →

Recent Posts

  • The rise of self-service BI, PowerPivot and Power BI and how it changed the world with Rob Collie
  • AI, Machine Learning and Power BI with Rafal Lukawiecki
  • The rise and history of Power BI with Amir Netz
  • Building a Power BI Center of Excellence with Alex Garcia
  • Guest on the Rob Collie (PowerPivotPro), Raw Data By P3 podcast

Top Posts

  • Use IsInScope to get the right hierarchy level in DAX
  • How to point existing reports to a new dataset in Power BI (even from AAS)
  • Get the YTD of the same period last year
  • Use more variables in DAX to simplify your life
  • Showing only slicer data that have facts in Power BI (and other fun tricks)
Subscribe:

feedburner Via RSS
Via Email

Blog by:
Kasper de Jonge
Program Manager at the Power BI team
Microsoft
linkedin
Terms of use
 
DAX formatted by:
DAX Formatter by SQLBI
Privacy & Cookies: This site uses cookies. By continuing to use this website, you agree to their use.
To find out more, including how to control cookies, see here: Cookie Policy
© 2023 Kasper On BI / Powered by WordPress / Theme by Design Lab
 

Loading Comments...