Forum Discussion

habibsyed01's avatar
habibsyed01
Regular Visitor
8 years ago

Accessing Previous records!

Hello Everyone!   Scenario Here is my situation. I have a table/view that records every transaction. In Power BI I have aggregated the table to show summary for each day for last 8 days. I have a ...
Anonymous's avatar
Anonymous
Not applicable
8 years ago

habibsyed01,

I make a test using the sample table below. And create the following columns.

Index = RANKX(FILTER(Table3,Table3[Date]<EARLIER(Table3[Date])),Table3[Date],,ASC,Dense)
last 7 days value = CALCULATE(SUM(Table3[Value]),FILTER(Table3,Table3[Index]=EARLIER(Table3[Index])-7))



If the above DAX don't help, please share sample data of your table that can be copied and pasted here. Also post expected result in the forum.

Regards,
Lydia