Want to look up values that correspond to certain date ranges and match them to dates? Read on.

I recently came across an interesting use case for the Groupby function in DAX, and while doing so, thought it would also make a great example for explaining evaluation context in DAX. Consider the following table of data showing purchase requirements for two products, from multiple suppliers. Each product/SKU combination can only be bought in […]

Seasonality is an important phenomenon to consider for many businesses, and in the context of this post refers not only to seasons in terms of Winter, Summer, and so on, but will also consider how you can report on business activity in terms of custom-defined seasons. To state the obvious, an ice cream shop might […]