Power BI's equivalent of LAST()

[kaka]

So in tableau, LAST() basically returns the number of rows form the current one to the last one in the view/partition. 

Is there a similar function in power bi DAX ? 

[v-yulgu-msft]

Hi @kaka,

As per my knowledge, there is no such a function supported by Power BI DAX. 

But you can try this workaround. Insert an index column first, then add a calculated column using below formula:

Column = CALCULATE(LASTNONBLANK(TableName[Index],1),ALL(TableName))-TableName[Index]

Thanks,
Yuliana Gu

[MattAllington]

Sorry, this is not easy to understand what you are talking about.  Can you have another try