Forum Discussion

panipat1990's avatar
panipat1990
Helper III
8 years ago
Solved

How to restrict data in query editor

Dear Team,   I am new in power bi.i have a requirement. i have a table where 3 years data.but i want to load only 4 to 5 month's date's data.. how is possible in power bi..that it loaded only 4 t...
Need Help
  • Anonymous's avatar
    Anonymous
    8 years ago

    HI panipat1990,

     

    I think you are talk about query parameter which create in query editor, right?

    If this is a case, current query parameter can setting dynamic list from other query, but it not support setting dynamic value based on above list.

     

    For your requirement, I'd like to suggest you direct use #"query name"['column name'] with list.max function to get dynamic value, then use it in filter steps.

     

    Sample:

     

    Regards,

    Xiaoxin Sheng

Phil_Seamark's avatar
Phil_Seamark
Microsoft Employee
8 years ago

I created a blank query and used the following M code and named it dateParam

 

let
    Source = Date.From(Date.AddMonths(DateTime.From(Date.StartOfMonth(DateTimeZone.FixedUtcNow())),-4))
in
    Source

This generated a single value of 1/12/2017  (d/MM/yyyy)

 

I then edited my main table to incorporate this parameter in a filter

 

    #"Filtered Rows" = Table.SelectRows(#"Changed Type1", each [Date] > dateParam)

I've attached a simple model to show it working.

 

 

panipat1990's avatar
panipat1990
Helper III
8 years ago

Kindly guide me step by step i didnot understand.where i applied same step