Forum Discussion
Previous Row Date
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.
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.
Hi,
It is easier to do this in a calculated column formula. Would you be interested in that?
Hi,
Yes, but when I run the filters, the calculated column does not display the values correctly. Would you have an example calculated column?
Hi,
I can try to solve this with a measure. Can you share the link from where i can download your PBI file.
Hi sdiniz73 ,
Could you pls share some dummy data with expected output for test？
Best Regards,
KellyDid I answer your question? Mark my post as a solution!
Hi sdiniz73 ，
Is your issue solved now?Have you checked my last reply？
Best Regards,
KellyDid I answer your question? Mark my post as a solution!
