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
v-lid-msft's avatar
v-lid-msft
Icon for Community Support rankCommunity Support
6 years ago

Hi csudude ,

 

We can add a calculated column based on your date column, get the weeknumber start by Monday.

 

Please read this document to get detail about WEEKNUM function: https://dax.guide/weeknum/

 

Week = WEEKNUM([Date],2)

 

Then you can create silcer based on this column.

 

 


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.