Earn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.
Good morning Community,
I've trying to get the year week number based on the start and the end of the month date. I have the following columns: start, end, month. The start and end date indicate the range date for the column month. For instance there are ending dates that end in the next month but belong to January for example. here is an example of the table. However, if the week number is based on the date column I will end up with week 53 when the month reference is January so I want the week number to mach the month column so it is consistent. I hope I made sense 🙂
I appreciate any help you might be able to provide. Also if you have any other idea how to approach this please share them the column that are required tho are month, start and end
I've trying to get the year week number based on the start and the end of the month date.
Those things are violently incompatible. Use an external Calendar tabe that has all the required details.