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

Posted on August 9, 2017August 15, 2017 Analysis Services DAX Microsoft BI Power BI

Dynamic data comparisons using disconnected slicers, TreatAs and inactive relationships

Got a good question this week that had me scratching my head for a bit but then I remembered a new function that was added... Read more

Posted on June 1, 2017June 2, 2017 DAX Power BI

Use the Power BI quick calcs with your own date table

Just a quick one today on how you can use the Power BI quick calcs with you own date table. I have a very simple... Read more

Posted on February 13, 2017March 7, 2017 DAX Power BI

Automatically apply filters to your report per user

This was an interesting case I did a while ago where they wanted to have a report that automatically provided a set of filters to... Read more

Posts navigation

← 1 2 3

Recent Posts

  • Kasper On BI on developing Power BI & life of a Microsoft PM with Kim Manis
  • Kasper On BI on the journey from Excel to Power BI with Shannon Lindsey
  • Launching Kasper On BI YouTube and Podcast, for everything (Power) BI and Analytics
  • Refresh the table fully after setting up incremental refresh with TMSL
  • Hardcoding a calculation group in a measure

Top Posts

  • Show the refresh date\time in a Power BI report and dashboard
  • Currency conversion in DAX for Power BI and SSAS
  • Use IsInScope to get the right hierarchy level in DAX
  • Dynamically switching axis on visuals with Power BI
  • Automatically rotate through Power BI report pages on your browser
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
© 2021 Kasper On BI / Powered by WordPress / Theme by Design Lab