Forum Discussion

MarkCBB's avatar
MarkCBB
Helper V
10 years ago
Solved

Faster M needed

  Hello,   I am using the following Query in PBI Desktop, however it is really really slow:   let Source = Excel.Workbook(File.Contents(File_Dir & "\eXceler8\Projects\Excel Add-Ins\Clients\...
Need Help
  • ImkeF's avatar
    ImkeF
    10 years ago

    Hi Maxim :-)

    Are you sure that this will prevent the multiple calls to the SALES-table?

    To be on the safe side here it would look like this:

     

    SalesDate = List.Buffer(SALES[DATE]),
LMinSD = List.Min(SalesDate),
LMaxSD = List.Max(SalesDate),
#"Filtered Rows" = Table.SelectRows(#"Renamed Columns", each [DATE] >= LMinSD and [DATE] <= LMaxSD)
Greg_Deckler's avatar
Greg_Deckler
Community Champion
10 years ago

Out of curiousity, how many rows in your Excel file and how long is the process taking?