DAX query for given dates?

[AtikurRahman]

Hello,

At the moment we are using the following query to convey data to us based on YESTERDAY'S data:

= Webtrends.Tables("100886", Date.AddDays(Date.From(Date.From(DateTime.FixedLocalNow())), -1), Date.AddDays(Date.From(Date.From(DateTime.FixedLocalNow())), -1))

Now, if we change the -1 to -4, we will get data from 4 days before hand.

eg. Today = 16/08/2016

-4 = 12/08/2016

-5 = 11/08/2016

-3 = 13/08/2016

Unfortunately this only shows us data for that ONE date, what I want to do is to view data for a full 7 days prior to todays data. Is this possible, and if so how can we approach this?

Any advice would be appreciated.

Regards,

Atikur

[v-shex-msft]

Hi AtikurRahman,

According to your description, you want to view the data between today and seven days ago, right?

If as I said, you could use Filtered Rows to achieve your requirement, below is the query:

  #"Filtered Rows" = Table.SelectRows(#"Changed Type", each [Date] >= Date.From(Date.AddDays(DateTime.FixedLocalNow(),-7)) and [Date] <= Date.From(DateTime.FixedLocalNow()))

 

Before filter:

 

After filter:

 

If above is not help, please provide more detail info and feel free to let me know.

Regards,

Xiaoxin Sheng

[AtikurRahman]

@v-shex-msft Apologies for the delayed response.

Our team has carried out the work and managed to get it working to an extent, thanks for all the help Xiaoxin!

Regards,

Atikur