Forum Discussion
How to get daily dates and week date start
This formula only gives the week start date for the dates 01/01/2023, 01/02/2023...... I want to get week start dates for every week starting from Monday between 01 jan 2023 and 31 dec 2023.
- foodd3 years ago
Community Champion
To your data table, add the formula as a calculated column. Here is a screenshot of what it would look like with a shorted dataset; however, applies to the whole year of 2023.
Please add your work-in-progress Power BI Desktop file, and I will take a look.
- techy3 years agoRegular Visitor
Thanks for the solution. I have this column and in photo 1 is what i am trying to get that is all week's start date from 1 Jan 2023 to 31 dec 2023(ignore year 2024) but because i only have dates in photo 2 for 1st day of month, i get week start date for this first week. i want to get this photo 2 dates first drill down to daily dates and than drill down to week start date.
i cannot share the original files due to security reasons.