Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
3 years ago
Solved

FIlter Current week

Hi I have a table that I want filter away before loading in power bi, I have several week of data and just want to have current week. I have only yearweek in my fact table, im using same table to se...
Need Help
  • BA_Pete's avatar
    BA_Pete
    3 years ago

     

    You need to add a step name if you're putting it straight into Advanced Editor.

    It would look something like this:

    // This:

let
    Source = YourSource,
    SomeChanges = Function(Source, each DoStuff)
in
    SomeChanges

// ...would go to this:

let
    Source = YourSource,
    FilterRows = 
        Table.SelectRows(
            Source,
            each [YearWeek] = List.Max(Source[YearWeek])
        )
    SomeChanges = Function(FilterRows, each DoStuff)
in
    SomeChanges

     

    Pete

     

Vijay_A_Verma's avatar
Vijay_A_Verma
Most Valuable Professional
3 years ago

You can choose Transform data while pulling in the data into Power BI and in Transform Data (i..e. Power Query), you can reduce the amount of data before lading into Power BI. 

Ideally the best way is to way put a SQL query into your Power BI import so that data pulled from database is also lesser.

In first approach, full data will be imported but Power BI will be loaded with only required rows after you transform data.

If you use SQL Query to pull in only required rows, then operation will be faster as only required rows are imported.