Forum Discussion
Solved
Countrows for dates that match week start date
Hi I have a facts table which is a daily snapshot of lots of rows of data. I also have my dates table (both shown below) I am struggling to countrows of the facts table if the date added match t...
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
Hi amitchandak
thank you for the reply and link to some further reading. Using this I was able to resolve the issue.