Previous Row Date

[sdiniz73]

Hello, I would like to bring in a report the records containing the start date and the previous start date in the same line.
I've already done some calculations using "index", however, when applying a filter, the calculation does not bring the information of the previous date that is being displayed on the screen.

[sdiniz73 · Accepted solution]

Hello, sorry for the delay, but I ended up solving it by creating separate measures (not columns), it wasn't very nice but it was the only solution I got. I will soon put a template here. Thanks.

[v-kelly-msft]

Hi  @sdiniz73 ,

Thanks  in advance for sharing.🙂

Best Regards,
Kelly

Did I answer your question? Mark my post as a solution!

[sdiniz73]

The ultimate goal is this:

Display current and previous start date on the same line.

In sql found the function "lag" returns the information correctly.

To try to work around the problem, I changed the table data source to sql and in SQL I inserted the Lag.

It even works a little, but when selecting some filters, the information doesn't match.

/

In the example below, we have the desired information in Power BI using LAG (SQL) in the data source.

In the example below with the filters selected, the information is wrong

Using the Index, it works only on the table, when creating the report, the data is also lost.

[v-kelly-msft]

Hi  @sdiniz73 ，

Is your issue solved now?Have you checked my last reply？

Best Regards,
Kelly

Did I answer your question? Mark my post as a solution!

[v-kelly-msft]

Hi  @sdiniz73 ,

Could you pls share some dummy data with expected output for test？

Best Regards,
Kelly

Did I answer your question? Mark my post as a solution!

[Ashish_Mathur]

Hi,

It is easier to do this in a calculated column formula.  Would you be interested in that?

[sdiniz73]

Hi,

Yes, but when I run the filters, the calculated column does not display the values ​​correctly. Would you have an example calculated column?

[Ashish_Mathur]

Hi,

I can try to solve this with a measure.  Can you share the link from where i can download your PBI file.

[Ashish_Mathur]

Hi,

Share some data, describe the question and show the expected result.