Hi @Melissa
Kindly request you find attached the Excel with full date and week of month column created using power query Weekof month function and Weeknum column created using dax. As per the screen shot attached , what i need is week num column should step wise increase as per the week of the month value i.e. as said earlier if you look at the cells highlighted in yellow the week 5 for Jan 2020 ends at 31st Jan 2020. And at the same time new 1st week for Feb starts at 1st Feb and then the 2nd week from 2nd feb (starting Sun) . But now if you look at the weeknum function it extends the week 5 of Jan month till 1st Feb, where as in my case it should show 6 as the number i.e. 1st Week of Feb and 7 for 2nd week of feb. This would help me to get values as per my business scenario in the previous week calculation
excel has been also attached.
DateTest.xlsx (22.7 KB) Week on week.pbix (509.0 KB)
Have attached the Pbix file as well with Dates 2 table being created , it has the new weekof month column created as explained in above section .