Forum Discussion
calculate from second row
Hello everyone, I need to calculate a formula taking into account data from the second row. I show you an example in excel: I have a filter in Power BI by date, which will select t...
I loaded your excel data into a table called Second, and made a table visual and this measure, and put it on a card.
StartWithSecond = VAR filteredtable = FILTER('Second', 'Second'[Date]>min('Second'[Date]))return PRODUCTX(filteredtable, 1+'Second'[Value])-1If this solution works for you, please mark it as the solution. Kudos are appreciated too. Please let me know if not.
Regards,
Pat
mahoneypat
Microsoft Employee
Microsoft EmployeeI loaded your excel data into a table called Second, and made a table visual and this measure, and put it on a card.
StartWithSecond = VAR filteredtable = FILTER('Second', 'Second'[Date]>min('Second'[Date]))
return PRODUCTX(filteredtable, 1+'Second'[Value])-1
If this solution works for you, please mark it as the solution. Kudos are appreciated too. Please let me know if not.
Regards,
Pat
Regards,
Pat
Thank you so much mahoneypat !!
I was really complicating myself with collumns and so on... It works wonderfully!! Thanks again!