Forum Discussion

gduobaite's avatar
gduobaite
Helper III
5 years ago
Solved

Relative Date filter, working with weeks.

Dears,    I tryed to search the answer here, in forum, but without success..    I have a column chart with the amount of signed docs W29, W30, ....  Need to show the data of the last 8 calendar ...
Need Help
swise001's avatar
swise001
Continued Contributor
5 years ago

gduobaite 

 

Have you considered creating a Week 'offset' column in your date table?

 

This is essentially a column that marks the current week as "0" (so W37 = 0 ) and then as you go back in time each week it subtracts 1 (W36 = -1, W35 = -2)  

 

Then you can filter your visualization against this offset column.  (Where week offset >= -8  and week offset <= 0).

It becomes your own home grown relative date filter.  

 

Here are a few links for building an offset column (this can be done in power query or with DAX). 

 

https://www.oraylis.de/blog/how-to-create-relative-week-column-in-power-bi

https://radacad.com/offset-columns-for-the-date-table-flexibility-in-relative-date-filtering-for-power-bi

https://www.youtube.com/watch?v=NKr2TizM-KU