Forum Discussion

csudude's avatar
csudude
Frequent Visitor
6 years ago

Start Of Week

I'm in the processing of migrating my companies reports from Tableau to Power BI. However, I'm new to Power BI and I have a lot to learn.    In Tableau, I can quickly select the start of the week. ...
Need Help
csudude's avatar
csudude
Frequent Visitor
6 years ago

Thanks for the replies.

 

v-lid-msft Your information is helpful but not for this particular problem.  In addition to setting Monday to the start of the week, I need to filter on the last 12 weeks.  I need relative date filtering which I cannot do on an integer. 

 

I created a start of week date column in my date table that sets Monday to the start of the week: 

SoW = Dates[Date] - WEEKDAY(Dates[Date],2) + 1

 

After that, I used my SoW column in the date filter:

However, the filter still shows 7/14 (Sunday) to 10/5 (Saturday) and not 7/15 to 10/6 like I would prefer. Internally, Power BI is still recognizing Sunday as the start of the week. That's why I was hoping PBI had something like Tableau where I can tell Tableau Desktop / the data source that Monday is the start of the week and filters would reflect that.  

 

The good news is despite the incorrect dates being displayed in the filter, I am getting the values I expected.  I was worried that for the week of 9/30 (Monday) values for 10/6 (Sunday) would be excluded due to the filter showing 7/14/19-10/5/19.

 

v-lid-msft's avatar
v-lid-msft
Community Support
6 years ago

Hi csudude ,

 

We can create a parameter as a workaround to meet your requirement.

 

 

Then create a measure to judge the condition:

 

isInLastWeek =
IF (
    ISFILTERED ( LastWeekNumber[LastWeekNumber] ),
    IF (
        MAX ( 'Table'[Week] )
            >= WEEKNUM ( TODAY (), 2 ) - [LastWeekNumber Value]
            && MAX ( 'Table'[Week] ) <= WEEKNUM ( TODAY (), 2 ),
        1,
        0
    ),
    1
)

Put it into the Visual Filter and set greater than 0.

 


BTW, pbix as attached.

 

Best regards,

Community Support Team _ Dong Li
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.