Relative Report Level Filter in addiction to last entry

[Anonymous]

Hello togehter,

i have a new challenge for my report skills. i would set a filter for a diagram like this:

from max(sale_date) to max(sale_date)-30 days or 4 weeks or so. I want to show a review of the sale development of the last weeks. 

Ex:

last sale = 13.09.2018

then filter from 16.08.2018 to 13.09.2018. Its equal for these if its excatly 30days four weeks or one month.

Know anyone something to realize these in Power Bi?

Many thanks

Pascal

[v-danhe-msft]

Hi @Anonymous,

Could you please share some sample data to have a test and post your desired result if possible?

Regards,

Daniel He

[Anonymous]

i have uploaded some sample data

https://c.web.de/@319393602725741022/jYblD6zgSoKBpuaAT949sA

The Password for download ist "testdata"

Size is 6MB.

Many thanks to all

Pascal

[Anonymous]

hi @v-danhe-msft 

coud you help me with your experience?

Thanks

Pascal