Forum Discussion
Read previous rows from dates
Try this
Column = VAR _PreviousDay = MAXX ( FILTER ( MyTable, MyTable[Date] < EARLIER ( MyTable[Date] ) && MyTable[Status] <> "OFF" ), MyTable[Date] ) VAR _result = SUMX ( FILTER ( MyTable, MyTable[Date] < EARLIER ( MyTable[Date] ) && MyTable[Date] >= _PreviousDay ), MyTable[Cost] ) RETURN _result
Did I answer your question? Mark my post as a solution!
Appreciate with a kudos 🙂
New_be did you check my original post?
nandukrishnavs i do check your solution and it is awesome! But i think i wrongly asked before. Pardon for that. My question is how can i get previous data like in this image that i draw. For example, if the date 27/5/2020 (wednesday) and we have 4 days off from 23-26 May 2020, then i want to take the data from before the last date off that is from 22-26 May 2020. And then the value for 27/5/2020 (wed) will b e the sum of cost from22-26 May 2020.
I dont know whether it is possible to do that in power bi, but i hope with your help, i can learn something new 🤗
Try this
Column = VAR _PreviousDay = MAXX ( FILTER ( MyTable, MyTable[Date] < EARLIER ( MyTable[Date] ) && MyTable[Status] <> "OFF" ), MyTable[Date] ) VAR _result = SUMX ( FILTER ( MyTable, MyTable[Date] < EARLIER ( MyTable[Date] ) && MyTable[Date] >= _PreviousDay ), MyTable[Cost] ) RETURN _result
Did I answer your question? Mark my post as a solution!
Appreciate with a kudos 🙂can i change my(cost) column in your code into a measure? i mean, can i use measure instead of column?