New OFFSET DAX function 🎉

✨A new DAX function that is already available in the September release of #PowerBIDesktop, but was hidden in the last updates announced in September.

✨#OFFSET allows to make comparisons in context between two values, without writing extremely long and complex #DAX.

✨In my example, I compare with the previous product row, so I put -1 as the first parameter, and in the second parameter I specified the comparaison table which in my case is All (Product[Color]), then I specified the order with the #ORDERBY function, to define what the first row will be.

✨The function is not yet announced nor documented by Microsoft but works perfectly, I let you test it:

👉A perfect article about the function by Marc Lelijveld