Calculate last filled columns

[kasife]

Guys, hello!

How could I identify the last week filled in and the one before the last filled in so I can calculate the difference between the two? Would it be possible?

[Ahmedx · Accepted solution]

pls try this

List.LastN(
List.Select( Record.FieldValues(_), each _ <> ""),2){1}
-
List.LastN(
List.Select( Record.FieldValues(_), each _ <> ""),2){0}

[kasife]

Thanks @Ahmedx 

[Ahmedx]

Share sample pbix file to help you.

[kasife]

@Ahmedx following the link https://ufile.io/brvxhmrm