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: DAX

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 November 12, 2019November 12, 2019 Analysis Services DAX Power BI

Find all queries to Azure AS from a Power BI report or dataset

I recently found out the SSAS team added new trace information to Azure Log analytics. The new information allows you to find out the report... Read more

Posted on October 22, 2019October 22, 2019 Analysis Services DAX Microsoft BI

Figure out which columns and measures are used in your SSAS Tabular model

I got an interesting question about being able to figure out which measures and columns are being used for all tabular models in a server,... Read more

Posted on July 24, 2019July 25, 2019 DAX

Using DAX variables in iterators

I was having a discussion earlier this week about the use of variables I used in my currency conversion blog post . The question was... Read more

Posted on May 8, 2019May 8, 2019 DAX

Get the YTD of the same period last year

I was looking at my blog stats and found that some of the most popular posts are almost 10 years old (yes really). Those topics... Read more

Posted on January 10, 2019January 11, 2019 DAX

Use more variables in DAX to simplify your life

Today I ran across a pretty straightforward DAX challenge that is made so much simpler thanks to variables. So I decided to share it. Remember... Read more

Posted on December 17, 2018January 17, 2019 Analysis Services DAX Power BI

On demand webinar: Strengthen Your Data Modeling Skills with Power BI

I recently did this webinar for Power BI in the studios in Redmond. The webinar goes into details on the data model with Power Query,... Read more

Posts navigation

1 2 3 →

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