I need to get the Max Week number which is having the data using Calendar Table

[Anonymous]

Hi All,

         I am using Date table to get last 4 weeks data for that i have used below calculated columns.

Weeks = DATEDIFF(TODAY(),Dim_MasterCalendar[Date],WEEK)

Last 4 Weeks = IF(Dim_MasterCalendar[Weeks]>=-3 && Dim_MasterCalendar[Weeks]<=0, "Last 4 Weeks")

here i am having the data upto 33 week but the current week is 37. when i select last 4 weeks filter its not showing any data hence data is not present, look at the below visual.

So my requirement is to get the data from 33 week to last 4 weeks which is having the data. please suggest me a way to get this requirement. 

[jdbuchanan71 · Accepted solution]

Hello @Anonymous 

One thing you could do is instead of using TODAY() you could use the highest date in your detail table.

Weeks = DATEDIFF( MAX ( YourTable[Date] ) ,Dim_MasterCalendar[Date],WEEK

That way week 0 would be the oldest week where you have detail rather than the week of today.