Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
3 years ago
Solved

Last 7 Days Data Based on a Parameter

  = Table.SelectRows(#"Set Data Types", let latest = List.Max(#"Set Data Types"[Gas Day]) in each ([Gas Day] <= latest) and ([Gas Day] >= Date.AddDays(latest,- 7) ))     Hi All   I found the ...
Need Help
  • artemus's avatar
    artemus
    3 years ago

    Remove the ) after #"Gas Day Executed"

Anonymous's avatar
Anonymous
Not applicable
3 years ago

Well that was a schoolboy error!

 

Thanks a lot!