• Zur Hauptnavigation springen
  • Skip to main content
  • Zur Hauptsidebar springen
  • Zur Fußzeile springen

THE SELF-SERVICE-BI BLOG

Wir lieben Microsoft Power BI

  • Live Online Power BI-Schulungen
  • Beratung
    • Was ich für Dich tun kann
    • Showcases
  • Kunden
  • BLOG
    • Business Topics
    • Technical Topics (english)
    • Tools
  • Podcast
  • PUG Hamburg
    • PUGHH Anmeldung
    • PUGHH Recordings
    • PUGHH (interner Bereich)
    • Power BI UserGroup bei Xing
  • Kontakt
  • Über

Technical Topics

While all the other posts on this blog are in German, the Technical Topics are my way to contribute to the international Power BI community. The intention is to help others with these great tools and to learn myself from getting your comments. Enjoy.

Technical Topics (english) / 9. August 2019

Pitfalls with Table.ColumnsOfType

I recently came across a behavior of the Table.ColumnsOfType() function that I want to share with you today. Since this post talks about ascribed types in M, I …

[Weiterlesen...] Infos zum Plugin Pitfalls with Table.ColumnsOfType

Technical Topics (english), Tools / 9. Juli 2019

How to identify Measures not used in your pbix file

WARINING: Due to a broken DMV in Power BI Desktop, that I use for this solution, we cannot use this tool anymore, until until Microsoft fixes the issue. Sorry …

[Weiterlesen...] Infos zum Plugin How to identify Measures not used in your pbix file

Technical Topics (english) / 11. Juni 2019

Ascribed types in M: why to generally avoid them

I recently stumbled across the topic 'ascribed types' in M after a while and had a very informative conversation with the Power Query dev team about it. In this …

[Weiterlesen...] Infos zum Plugin Ascribed types in M: why to generally avoid them

Technical Topics (english) / 14. Mai 2019

Records in Power Query – how, when and why

The M language has so-called structured values, to which lists, records and tables belong. Each value type serves specific purposes and this post is intended to …

[Weiterlesen...] Infos zum Plugin Records in Power Query – how, when and why

Technical Topics (english) / 1. Mai 2019

Lists in Power Query – how, when and why

The M language has so-called structured values, to which lists, records and tables belong. Each value type serves specific purposes and this post is intended to …

[Weiterlesen...] Infos zum Plugin Lists in Power Query – how, when and why

Technical Topics (english) / 11. März 2019

Join types in Power Query – SEE how it works

"Merge queries is one way to combine queries (or even different tables within the same query) in Power Query/M. This topic has already been extensively written …

[Weiterlesen...] Infos zum Plugin Join types in Power Query – SEE how it works

Technical Topics (english) / 29. Januar 2019

Query time periods with CUBE formulas in Excel

If your Excel file contains an Excel data model, you have the possibility to query this data model using so-called CUBE formulas within the Excel cells. This …

[Weiterlesen...] Infos zum Plugin Query time periods with CUBE formulas in Excel

Technical Topics (english) / 17. Dezember 2018

Pivot shows values that are not part of the excel data model

I recently tried to help a customer who contacted me by phone with the following words: Lars, in my pivot data appear which are not contained in my Excel data …

[Weiterlesen...] Infos zum Plugin Pivot shows values that are not part of the excel data model

Technical Topics (english) / 15. Oktober 2018

Culture codes in M functions

At the time of writing (October '18) there are 35 functions in M that accept a parameter called culture. The functionality of this parameter is relatively easy …

[Weiterlesen...] Infos zum Plugin Culture codes in M functions

Technical Topics (english) / 29. September 2018

My personal Best of Power BI @ MS Ignite 2018

This is my personal Best of Twitter tweets regarding Power BI news from MS Ignite 2018. Thanks to all Ignite participants who shared their experiences with the …

[Weiterlesen...] Infos zum Plugin My personal Best of Power BI @ MS Ignite 2018

« Vorherige Seite
Nächste Seite »

Haupt-Sidebar

WEBSITE DURCHSUCHEN

Awards

Tweets

Tweets von @SchreiberLars

series of posts

Lists, Records and Tables in M - how, when and why
Writing Documentation for custom M functions
The Environment concept in M for Power Query in Excel and Power BI Desktop
Creating asymmetric Pivots and control them by Slicer

Footer

Kontakt

THE SELF-SERVICE-BI BLOG
Mail: lars@ssbi-blog.de

Rechtliches

  • Impressum
  • Datenschutz

Über THE SELF-SERVICE-BI BLOG

Ich bin ein freiberuflicher Power BI-Berater, -Entwickler und -Trainer und wurde von Microsoft mehrfach mit dem MVP Award ausgezeichnet. Ich arbeite mit einem kompetenten Netzwerk aus freiberuflichen und ambitionierten Kollegen zusammen. Erfahre hier mehr.

Social

Folge mir...

Copyright © 2023 · Digital Pro on Genesis Framework