Need sum of last 4 weeks data

[Lobo]

Hi Fellas,

Need a formula (measure ) where upon selecting a week I need to get the sum of last 4 weeks data.

Example If I select week 1735 my last 4 weeks measure should contain sum of  1735,1734,1733 and 1732. This has to be dynamic.

The tables I have are

1. Fact table with Sum of sales by week 

2. weeklink table with unique list of weekcode.

Any help is greatly appreciated ...

[v-caliao-msft · Accepted solution]

@Lobo,

For this requriement, please refer to the link belwo to see my post.

http://community.powerbi.com/t5/Desktop/Show-data-of-last-months-from-a-particular-month-filtering-w...

If this is not what you want, please provide us some sample data, so that we can make further analysis.

Regards,

Charlie Liao

[v-caliao-msft · Accepted solution]

@Lobo,

For this requriement, please refer to the link belwo to see my post.

http://community.powerbi.com/t5/Desktop/Show-data-of-last-months-from-a-particular-month-filtering-w...

If this is not what you want, please provide us some sample data, so that we can make further analysis.

Regards,

Charlie Liao

[Lobo · Accepted solution]

Thanks for reaching out...

However, I had once seen in one of the blogs a very simple measure using the duration DAX.

Anyway I will use your approach ... 

My Model looks like this 

Regards,

Lobo