Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
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.
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.