Logical functions like If/Then , Cases, And/Or or In statements are a fundamental part of creating customer vizzes – and they are not that hard

The most frequently searched post on my blog is on how to do YoY and YTD calculations. But it only works with actual calendar dates.

We see and use averages every day –  Average rainfall, MPG, or sales per day for example –  You learned how to calculate them in

Using filters with Fixed LODs causes problems for many users.  Here we will see "How-to" write a LOD When and how to apply Context or

For new and more advanced users, alike Parameters are misunderstood and misapplied! Parameters are a function that allows the user to manually input a single

Include and Exclude – the other 2 LODs – How often do you use them? If you are like most, less than 20% of the