Forum Discussion
Countrows for dates that match week start date
cottrera , not very clear. You can get start of week like
Sunday start
Week Start date = 'Date'[Date]+-1*WEEKDAY('Date'[Date],1)+1
Monday start
Week Start date = 'Date'[Date]+-1*WEEKDAY('Date'[Date],2)+1
Others refer: https://community.powerbi.com/t5/Community-Blog/Any-Weekday-Week-Decoding-Date-and-Calendar-2-5-Power-BI-Turning/ba-p/1187482
You can compare that with date you got and create a flag
cottrera , not very clear. You can get start of week like
Sunday start
Week Start date = 'Date'[Date]+-1*WEEKDAY('Date'[Date],1)+1
Monday start
Week Start date = 'Date'[Date]+-1*WEEKDAY('Date'[Date],2)+1
Others refer: https://community.powerbi.com/t5/Community-Blog/Any-Weekday-Week-Decoding-Date-and-Calendar-2-5-Power-BI-Turning/ba-p/1187482
You can compare that with date you got and create a flag