Power Query – Merging/Joining
In todays edition I will show you how to merge or join queries in Power Query. Power BI example: 20250813_BLOG_QUERY_JOIN.pbix
DAX – PreviousMonth() Function
In todays BLOG post I will explain how to calculate the value of a KPI for the previous month. In DAX there are existing so called Time Intelligence Functions which make it pretty easy to perform stuff like that. Power…
SQL Crossjoins
In todays BLOG post I will explain crossjoins in SQL to you. Also when they are generated and maybe also when you have to use them. SQL Example: 20250813_BLOG_CROSSJOIN.sql
Oracle Analytical Functions ( German )
I found an old video which I want to post as my first real blog entry. It’s about analyitcal functions in SQL databases. The examples are done with Oracle database but should work on other databases as well.
Welcome to my new BLOG!
I welcome you on my new BLOG. I will post news, tipps and tricks for databases ( Oracle, MS SQL, MySQL, Postgres, … ), Python, data science and Microsoft Power BI on a weekly base. If you have questions on…