DAX to show all N completed weeks data

[mohan_g_das1986]

I'm trying to create a Trend graph for last 13 completed weeks, A week runs from Monday to Sunday. See examples below. Help me show last any N completed week excluding incomplete weeks

1. When Today is July 10, 2019 - Last Completed Week is - July 01, 2019 (Monday) to July 7, 2019 (Sunday)
2. When Today is July 20, 2019 - Last Completed Week is - July 08, 2019 (Monday) to July 14, 2019 (Sunday)

Mohan

[sokg]

Hi @mohan_g_das1986 

Please, can you show us your calendar table?

[mohan_g_das1986]

I dont have Week number in this table,.. i have Start of Week & End of Week date

[sokg]

I think you solution is to add in your calendar table a week offset column.

Avi explains that very good at the link below

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

Also you can download this calendar table. Link in the video description .

Hopefully this is what you are looking for!

[mohan_g_das1986]

This is not working as we wanted - using the Offset number only when i click on -2 i sent my numbers that to with current week, but for other selections no answer

[sokg]

Please put your CurWeekOffset in the filter pane as show in the pic below

and click apply filter.

Hopefully this is what you are looking for!