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: Analysis Services

Posted on March 29, 2018March 29, 2018 Analysis Services DAX

Using variables to split up your calculations

Got a DAX question recently that I solved using variables. When I walked them through the solution someone exclaimed “I didn’t know you can do... Read more

Posted on March 8, 2018March 13, 2018 Analysis Services DAX Power BI

Dynamic relationships based on the selection

Got an interesting question recently where someone wanted to be able to switch the relationships automatically based on which slicer was selected. Take the following... Read more

Posted on December 8, 2017December 8, 2017 Analysis Services Power BI

To DirectQuery or Not to DirectQuery, that is the question..

Usually I start my blog posts with an interesting question I got, this time we will do the reverse. I want to talk about a... Read more

Posted on October 17, 2017March 16, 2018 Analysis Services Gateway Power BI

Change your Power BI report to point to an external SSAS model

A common questions I get is to change the connection string to from my report to SSAS after I move my Power BI desktop file... Read more

Posted on September 28, 2017July 20, 2019 Analysis Services DAX Power BI

Currency conversion in DAX for Power BI and SSAS

Another interesting question that came up recently is how to do currency conversion in Power BI. My colleague Jeffrey Wang had a very neat solution... Read more

Posted on September 22, 2017November 15, 2018 Analysis Services Gateway Power BI

Using CUSTOMDATA and On-Premises SSAS with Power BI Embedded

Another Power BI embedded blog post while I have a playground up and running. Often when you want to use SSAS with Power BI embedded... Read more

Posted on September 6, 2017September 7, 2017 Analysis Services DAX Power BI

Filter data based on a comma separated list using CALCULATE and PATHCONTAINS, even with external models!

Another interesting question I got this week kind of extends on the previous blog posts where I used disconnected slicers to filter data  but this... Read more

Posted on September 1, 2017June 28, 2019 Analysis Services DAX Microsoft BI Power BI

Use calculated tables to show only used rows in dimensions

UPDATE: you can now use measures as filter of a slicer so this post is outdated, please read here for what the recommendation is today:... Read more

Posts navigation

← 1 2 3 4 … 12 →

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
  • Get the YTD of the same period last year
  • Power BI Desktop Dynamic security cheat sheet
  • Showing only slicer data that have facts in Power BI (and other fun tricks)
  • How to point existing reports to a new dataset in Power BI (even from AAS)
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