First() and Last()
When working with table calculations requires you to know where you are in a table and how things are calculated one of the tools needed is some sort of indexing, there is an Index() calculation but I've found that first() and last() have been more useful for me. They look at where the position is based upon either the first or last element in a partition. Here is an example where we are calculating based on table across.
and then pane across
these two functions have the most use when paired with another powerful table calculation the lookup as we will see in part 3.
Hopefully this short look at first() and last() has been helpful subscribe to @cloudstream_uk for more #TodaysTableauTip