Once in a while one comes across a project which has a simple assignment and obvious justification in business world but it is still challenging to transform into technical solution. Use case described below is a good example how to work with specific time periods in Power BI. Even though the week is not partContinue reading “Week Based Time Intelligence in Power BI”
Category Archives: Data Analytics
SQL Wildcards and Their Pitfalls
With the use of wildcards in SQL code comes great power, but also great responsibility. I do not want to describe all the possibilities which arise with using wildcards. We can easily find it here. I would look at the whole thing the other way around. And that’s when wildcards appear in our code withoutContinue reading “SQL Wildcards and Their Pitfalls”
Nondeterministic Behavior in SQL – When the Same Script Gives Different Results
One of the worst things that can happen to you as a BI developer is when your report gives bad results. You look at the underlying code, which looks fine at first glance, you run it again in the database UI, and the result is suddenly correct. So you update the report and everything isContinue reading “Nondeterministic Behavior in SQL – When the Same Script Gives Different Results”