Mimicing Excels sumif / Vlookup without data manipulation

Update 23 November: As some have noticed, would it not be easier to just do a window_sum(sum[hour_hours])) and compute that by Answer is: yes. The original question was phrased differently with the user asking to also deduct several values which, in retrospect was not what he wanted. All he wanted was to just sum the … Continue reading Mimicing Excels sumif / Vlookup without data manipulation

Keeping a constant number of returned rows

In today's question we will be answering how we can keep the returned results limited to a defined/definable number of rows. That means for example if we say we want only 200 rows to be returned but we have four different segments then each segment should only hold 50 results. If we increase to 300 … Continue reading Keeping a constant number of returned rows

Summing profit & loss whilst maintaining stock value for balance sheet with a single day slider filter

Being a finance guy by background, this question from the forums got me straight away. The request was to find a solution where a single value slider (this is important) filter could be used on a daily basis but when the "All" function was used, it should only sum up the values for the profit … Continue reading Summing profit & loss whilst maintaining stock value for balance sheet with a single day slider filter

Filling the gaps – three levels of difficulty

Forums are most fun when a question really makes you think. For today’s blog post, we will be revisiting a question that asked how a table with missing values, i.e. nulls, could be filled not with the preceeding value but with the following value. Also, there can be multiple instances of null values in succession. For this exercise, however, we will be going through three levels of difficulty to gradually evolve our understanding.