Solved: EARLIER

Captuleio · ‎06-21-2019

Olá!!!

Estou tentando utilizar a EARLIER para cálculo, mas apresenta a seguinte mensagem:

EARLIER/EARLIEST faz referência a um contexto de linha anterior que não existe.

Abaixo imagem do modelo:

Obrigado

Captuleio

MattAllington · ‎06-22-2019

This is not a power query question but a DAX question. Looks like you are writing a measure. In this scenario there is only a single row context (in the filter) so there is no “earlier” row context.

* Matt is an 8 times Microsoft MVP (Power BI) and author of the Power BI Book Supercharge Power BI.
I will not give you bad advice, even if you unknowingly ask for it.

View solution in original post

MattAllington · ‎06-22-2019

This is not a power query question but a DAX question. Looks like you are writing a measure. In this scenario there is only a single row context (in the filter) so there is no “earlier” row context.

* Matt is an 8 times Microsoft MVP (Power BI) and author of the Power BI Book Supercharge Power BI.
I will not give you bad advice, even if you unknowingly ask for it.